Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last Name parameter allow all data on first run

Status
Not open for further replies.

lanm

Programmer
Jul 7, 2005
244
US
I have a query that uses a parameter for a person's last name in the where clause. I'd like to figure out how to get the report to pull all names the first time the report is run, then allow the user to specify specific records afterwards.

I can't get the default values right, or I'm missing something else.

Thanks!
 
Got it:

check the allow "Blank Value" box for the parameter, then click "View Report" when the report is run!


Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top