Need query of all records based on month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:])
 
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:])
 
Back
Top