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

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

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Howard" wrote:

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

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


"Jerry Whittle" wrote:

> 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.
>
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Howard" wrote:
>
> > 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
> > --
> > Howard

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


"Jerry Whittle" wrote:

> 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.
>
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Howard" wrote:
>
> > 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
> > --
> > Howard