Add Date to Query with Prompt

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

Guest

I have a query with an added field of [AsofDate]. The field is simply
AsofDate: #06/07/2007# Each time I run the query, I have to open in design
view and change this date. I'd like to add a prompt or parameter to prompt
me for this date, so that I do not have to open query and change each time.
I appreciate any help!! Thanks!
 
In your query, put:

AsofDate: CDate([Enter the date to use])

Alternatively, you could have it refer to a date on an open form using:

AsofDate: CDate([Forms]![NameOfForm]![NameOfControl])
 
LuvinLife said:
I have a query with an added field of [AsofDate]. The field is simply
AsofDate: #06/07/2007# Each time I run the query, I have to open in
design
view and change this date. I'd like to add a prompt or parameter to
prompt
me for this date, so that I do not have to open query and change each
time.
I appreciate any help!! Thanks!
Click to expand...

Search the help for "parameter query".

Keith.
www.keithwilby.com
 
Back
Top