Using more than 1 query for a Report Form

[Jackie]

I have 2 requirements for a report.&nbsp;&nbsp;The first requirement is to produce the report for all divisions.&nbsp;&nbsp;The second requirement is to produce the report for a selected division.&nbsp;&nbsp;A report parms screen is displayed for both reports.<br><br>I would like to use the same form for both queries. What is the proper syntax for setting the RecordSource property for the report?<br><br>Where would the record source property be set? I put the code in the &quot;ON Open&quot; event for the report after the Report Parms screen is displayed and the report was run with the &quot;all&quot; version.<br><br>Thanks for your help.

 

[DougP]

Try this <br>In your query put an &quot;ask&quot; Parameter such as<br><br>Like [Enter Division] & &quot;*&quot; <br><br>in the Division field.<br>Then run th equery and enter a valid division and see if it returns the correct results.<br>Next Run your query again except this time do not key anything in, just press the Enter Key.<br>See if your query returns all divisions.<br>Then you need only one query for your report.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.