Need help with date issue.

[ITChevyUSSNY]

I am aboard a US Navy ship and have created a data base to keep track of my users. My users have to do a yearly training about keeping the network safe and if its not done they loose their access. The table I have keeps track of the date of their current training and when it expires. What i want is in a report that i generate, which has all the users listed with the date of their IA expiration to have the users who are a month from expiration to be in yellow or some other color and the users who are past expiration to be red. Can this be done? How would I do it? Please I need help with this...

Thanks in advance.

"Never Forget"

[RuralGuy]

Conditional formatting works in reports. Have you looked at it?

[ITChevyUSSNY]

No I havent how would I go about doing it?

[RuralGuy]

In design view, select a control and right click and go to Contitional Formatting.

[ITChevyUSSNY]

Cool that helps me alot with some other stuff I am doing but the problem I am having now is I don't know how to set up the conditional formatting so it will change the color of the text when its after todays date or when its a month away. Have any ideas? Thank you so much for your help... I really appreciate it...

[RuralGuy]

Did you use the "Expressen Is" function? If so, what did you put in there?

[ITChevyUSSNY]

[IA Expiration]>Today This is the experssion I am using for anything after the expiration date to turn red.[IA Expiration]= 0 This is what I am using for users who dont have a date inputed to highlight them red.I dont know how to even set it up to have it 30 days prior to expiration...

[RuralGuy]

So this is a control that displays the [IA Expiration] field? I assume it is a DateTime field? I don't believe there is a built in Today() function. Did you create one?

[ITChevyUSSNY]

No I have not, is there another way of getting todays dat or something like that? I am totally lost here, I am sorry...

[RuralGuy]

Please answer these questions:

So this is a control that displays the [IA Expiration] field? I assume it is a DateTime field?

The Date() function returns the current date with the time set at midnight and Now() returns the current Date and Time.

[TNich]

Ok, I'm doing something similar but I just need it to turn red on the expiration date. After reading what you guys are posting I know that I'm looking at the expression but what would the formula be? I would appreciate any help you can give, just got tasked with this project and I have to have it up and running soon. Very new to access when it comes to editing.

[RuralGuy]

Not enough information to properly assist and you should have started a new thread. Is it a Report or a Form?

[TNich]

Sorry it's a report and this thread was sent to me from a friend trying to help. Still Learning the etiquette for posting in the forums.

[RuralGuy]

Tagging on to old threads (4 years old) limits who can see your issue. Far more helpers would see it if you started a new thread. Having said that, you could use Conditional Formatting to change the color of your control in a report. There are several ways but that is probably the easiest.