Query Search Criteria

[Chuck216]

Hi

This seems like it should be very simple, but I can’t get it to work.
I have a query with a date field what I would like to do is in the criteria
of the date field
I want to search for only the current month. I have tried
Format(Date(),"mm") but this doesn’t work.

Thanks in advance for any help with this.
Chuck

 

[TedMi]

Add two fields to your query
MyYear: Year(myDateField), with Criteria Year(Date())
MyMonth: Month(myDateField), with Criteria Month(Date())

You need not check the Show boxes for these additional fields.

-TedMI

 

[Chuck216]

That Works Great

Thanks

Add two fields to your query
MyYear: Year(myDateField), with Criteria Year(Date())
MyMonth: Month(myDateField), with Criteria Month(Date())

You need not check the Show boxes for these additional fields.

-TedMI