Query and Report "enter parameter"

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

Guest

I have a query and report for a table with several Names in it. The query is
set up so that the criteria (under Name) is [enter name]. When the report is
run, it prompts for the name and issues a report for that name. Is there
something I can enter for the prompt so that it gives all data for all names?
 
RichN said:
I have a query and report for a table with several Names in it. The query is
set up so that the criteria (under Name) is [enter name]. When the report is
run, it prompts for the name and issues a report for that name. Is there
something I can enter for the prompt so that it gives all data for all names?
Click to expand...

Remove the criterion from the query. If you want to pass a filter to
the report, enter a valid filter (where clause without the WHERE
keyword) in the open event of the report.
 
One way is to use Like [enter Name], then if you type a * you will get all
records, if you type say C* you will get all names starting with C, if you
type Ca* you will get all names starting with Ca. etc
CurtainMary
 
Back
Top