Need query of all records based on month

J

jackle

How can i create a parameter query in the query grid to ask for all records
based on the month. example: i want all records for May 2007. any ideas?
 
M

Michael Gramelspacher

How can i create a parameter query in the query grid to ask for all records
based on the month. example: i want all records for May 2007. any ideas?
Click to expand...
say you have a date column in your table

Field: DatePart("m",[Orders].[OrderDate])
Criteria: DatePart("m",[Enter date:])
 
M

Michael Gramelspacher

How can i create a parameter query in the query grid to ask for all records
based on the month. example: i want all records for May 2007. any ideas?
Click to expand...
Oops. Should be

Field: DateDiff("m",0,[Orders].[OrderDate])
Criteria: DateDiff("m",0,[Enter date:])
 
Top