2003 Report

  • Thread starter Thread starter Trevor Aiston
  • Start date Start date
T

Trevor Aiston

I have areport based on a select query. The query has a criteria of
[Year]="0809"
Can i run a report which will prompt me for the criteria i.e 0304, rather
than rembering to modifying the query before running the report?

TIA

Trevor
 
Yes. Whatever you want the query to prompt you for, put in [ ]. So, [enter
date] will ask you for date.
 
Its not so much the 'prompt' i want its the value I want the query to lookup
which will then act as a filter.

So I want to be prompted for a year, enter 0809 or 0607 etc and the query
return values for that year.

Does that help

Golfinray said:
Yes. Whatever you want the query to prompt you for, put in [ ]. So, [enter
date] will ask you for date.

Trevor Aiston said:
I have areport based on a select query. The query has a criteria of
[Year]="0809"
Can i run a report which will prompt me for the criteria i.e 0304, rather
than rembering to modifying the query before running the report?

TIA

Trevor
Click to expand...
Click to expand...
 
Back
Top