date query parameter

  • Thread starter Thread starter James New
  • Start date Start date
J

James New

I am trying to write a query that would prompt the
operator to enter a year "YYYY" in order to retrieve the
records. The date field is fomated as "MM/DD/YYYY", how
would I set up the parameter so that only the year can be
selected.
Thanks in advance
 
In the design view of your query, insert the following in a Field: row

Year([MyDate])

Then, in the Criteria: row of that column, insert:

[Enter desired Year:]


hth,
 
Back
Top