lookup by date?

A

Annette

I need to make a query that looks up by date. It can be for the year or
month. I'm not sure how to do this. Any help would be greatly appreciated.
Thanks in advance.

Annette
 
G

gls858

Annette said:
I need to make a query that looks up by date. It can be for the year or
month. I'm not sure how to do this. Any help would be greatly appreciated.
Thanks in advance.

Annette
Click to expand...
Here's one way

In the criteria for the date field in your query put this
Between [Enter beginning Date] And [Enter Ending Date]

You will then be prompted to enter the date when the query is
run.

gls858
 
Top