Prompt??

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

How do you get a query to prompt the user to specify
which specific information you want it to retrieve? For
example: I want to be able to prompt the user to enter
which year they want the records from. Thanks in advance.

Jeff
 
You you have a field that contains the year? If so, put something like the
following in the query...

=[EnterYear]



If not, you will have to build a new column in your query to pull the year
out of your date field. Then you can put the above in the criteria for that
field.

Post back if you need more details.

Rick B


How do you get a query to prompt the user to specify
which specific information you want it to retrieve? For
example: I want to be able to prompt the user to enter
which year they want the records from. Thanks in advance.

Jeff
 
Back
Top