Date parameter query

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

Guest

I'm trying to allow entry of month/year only as user input to a query that
will pull out dates that fall in that month. Any ideas how I would do that
in the query grid?
Access 2003
 
One possible way to handle this would be to create a column in your query
based on this expression:
Date1: Format([YourDateField],"mm/yy")
In the criteria row you would have [Enter date as mm/yy]

Hope that is suitable.

Ed G
 
One field in your query grid needs to be the Month([YourDateField]) and one
needs to be Year([YourDateField]).

In the criteria "cells", you'd use parameters similar to:
[Enter Month number (1, 2, ..., 12)]
and
[Enter Year (yyyy)]
 
Back
Top