Checking to see if a date has past

[Howard]

I'm new at using Access. I have a expiration date in the data base, and I
need to check to see if that date is past due. If it is, I need to flag it
some way. I know how to do it in Excel, but not in Access. Any suggestions?
Thanks

 

[Jerry Whittle]

You create a query that can then be run by itself or used as the basis of a
report. There are many ways to do this depending on your needs.

You could put something like below in the criteria of the date field of a
query. It will then return any record that is overdue.

Date()

Or if the time is also important:

Now()

In a form or report you could also use conditional formatting to change
overdueh dates to a different color or font.

For any of this to work properly, the field in question must be a Date/Time
data type. If it's a text field that looks like a date, it will take a lot
more effore to get it to work correctly.

 

[Howard]

Thanks Jerry, I'll give this a try.
--
Howard

You create a query that can then be run by itself or used as the basis of a
report. There are many ways to do this depending on your needs.

You could put something like below in the criteria of the date field of a
query. It will then return any record that is overdue.


Or if the time is also important:



In a form or report you could also use conditional formatting to change
overdueh dates to a different color or font.

For any of this to work properly, the field in question must be a Date/Time
data type. If it's a text field that looks like a date, it will take a lot
more effore to get it to work correctly.

 

[Howard]

Thanks Jerry. I'll give this a try.
--
Howard

You create a query that can then be run by itself or used as the basis of a
report. There are many ways to do this depending on your needs.

You could put something like below in the criteria of the date field of a
query. It will then return any record that is overdue.


Or if the time is also important:



In a form or report you could also use conditional formatting to change
overdueh dates to a different color or font.

For any of this to work properly, the field in question must be a Date/Time
data type. If it's a text field that looks like a date, it will take a lot
more effore to get it to work correctly.