date query parameter

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,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"James New" wrote in message
...
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