Help with User Defined Report

[jdegeorge]

Hi:

I have a report with pre-defined fields (such as NAME, ADDRESS, CITY, STATE, ZIP, PHONE, etc.). I need several versions of this report based on different combinations of NAME, CITY and STATE.

How can I have only one REPORT and let the user define the NAME, CITY and STATE, where they can input values for SOME or ALL of the 3 fields? Is this possible? Thanks in advance.


Jim DeGeorge

 

[CosmoKramer]

Jim,

I don't know if this is still a problem for you or not, but here goes....

In your query, define the criteria for each field like the following syntax, straight across the grid so the criteria will be "ANDed", not "ORed":

For the "NAME" field:

 Like [Please enter the NAME] & "*"

For the "CITY" field:

 Like [Please enter the CITY] & "*"

For the "STATE" field:

 Like [Please enter the STATE] & "*"

This way, if nothing is entered, all records will be returned....




A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams

 

[jdegeorge]

Yes, I got it solved. Dhookom helped me out and then posted his response as a FAQl. Very powerful and very flexible.

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=3936

Jim DeGeorge