Access query issue

[shaunashavena]

I want to do a query to return all records that was processed within a specific month. The user will input the date and this date must be compared with those in the process field to return only those within that given month.

I need guidance how to get this done please.

 

[lespaul]

typed, untested:

using parameters (not recommended - you should really create a form that the user selects from)

SELECT * from SomeTable WHERE Month(SomeDateField) = Month([Please enter the date to search (mm/dd/yyyy)])

Leslie

Have you met Hardy Heron?