If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
date query parameter
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 |
Thread Tools | |
Display Modes | |
|
|