2003 Report

[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

 

[Golfinray]

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

 

[Trevor Aiston]

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

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

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