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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Option to choose from different parameters

Status
Not open for further replies.

swhitt

MIS
Aug 27, 2003
28
US
I have one report that I need to be able to query using different parameters at different times. For example, I may want to query by either Permit Number, Street Address, Street Name, or Block. All of these parameters are valid fields in the report but how to I run it using just one of the parameters and get it to ignore the others?
 
You could have a default value of "ALL" for the parameters.

And in your record selection:

if ?parm1="ALL" or tablename.fieldname = ?parm1
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top