Query Help

Hello, 

I have a table with the following fields:

• Program Name (Type: Text)
• Health Date (Type: Date)
• Health Color (Type: Text)

I would like to add a field that would automatically return the health color from the previous month. The desired end result would look something like:


I'm guessing this would be a query formula but so far I haven't had any luck. Any help is much appreciated! Thank you.

------------------------------
Addie Brunson
------------------------------