parameter pop up

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

Guest

Hi All,

Ive been using access for about 3 months now and i have to run a report
daily to produce yesterdays information on incidents. Everyday i have to go
into the query...ammend the date parameter...close the query and save
it...then run the report.

What i was trying to figure out how to do is forget about amending the date
in the query first and just run the report which on opening throws up a pop
up box asking for to enter a date for the report. Is this possible?

Thanks in advance
 
Benson said:
Hi All,

Ive been using access for about 3 months now and i have to run a report
daily to produce yesterdays information on incidents. Everyday i have to go
into the query...ammend the date parameter...close the query and save
it...then run the report.

What i was trying to figure out how to do is forget about amending the date
in the query first and just run the report which on opening throws up a pop
up box asking for to enter a date for the report. Is this possible?

Thanks in advance
Click to expand...

If it's it is just one date put [Enter Date] in the criteria
for the date field and you will get a prompt.

If it's a date range then use this:

Between [Enter Start Date] And [Enter End Date]

gls858
 
Back
Top