lookup by date?

[Guest]

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

 

[gls858]

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

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