Discussions

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
------------------------------

I may be able to help, but would like a little more info about the health color updates.  Does it update more than once a month?

------------------------------
Paul Peterson
------------------------------

Original Message:
Sent: 05-03-2022 15:15
From: Addie Brunson
Subject: 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
------------------------------

Original Message:
Sent: 5/6/2022 7:45:00 PM
From: Paul Peterson
Subject: RE: Query Help

I may be able to help, but would like a little more info about the health color updates.  Does it update more than once a month?

------------------------------
Paul Peterson
------------------------------

Original Message:
Sent: 05-03-2022 15:15
From: Addie Brunson
Subject: 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
------------------------------

How is it updated?  Is it updated at the same time each month?

------------------------------
Paul Peterson
------------------------------

Original Message:
Sent: 05-06-2022 20:09
From: Addie Brunson
Subject: Query Help

Hi Paul, 

No. It updates once per month. 

Thanks!

Original Message:
Sent: 5/6/2022 7:45:00 PM
From: Paul Peterson
Subject: RE: Query Help

I may be able to help, but would like a little more info about the health color updates.  Does it update more than once a month?

------------------------------
Paul Peterson

Original Message:
Sent: 05-03-2022 15:15
From: Addie Brunson
Subject: 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
------------------------------

Addie,

As long as you never duplicate a Health Date for a Program, this should be straightforward.

Your query would look something like



The use the Color variable in your report.

------------------------------
Don Larson
------------------------------

Original Message:
Sent: 05-03-2022 15:15
From: Addie Brunson
Subject: 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
------------------------------