Adding to a filter on a query used to select records for a report

[skyhighe]

I need to have a query with a basic Where clause which before the DoCmd is executed to run the report I then supplement the where clause with additional information.

I need to know 3 things...

1. Can a query have its Where clause supplemented with additional information
2. How do I get the new query annotated with the additional information
3. What I need to do to have the report do the changing to the where clause.

The report will make a determination of divisions and facilities from a form that is opened and hidden which was used to select those divisions/facilities. Then the report needs to change the query where clause and then execute the report.

Thanks in advance...

 

[dawnd3]

I am not quite sure what you mean by "suppliment with additional information". However, maybe this will help. You can either use combo/text boxes on a form to enter the criteria and then in the Docmd.openreport one of the arguements is the "where" condition. Or you can have the query filter it's data based off of the entry in the combo/text boxes. Or you can just create a parameter query that prompts you for the varied criteria each time you run the report that is based on that query. Does this help? Let me know if I can explain better. Dawn

http://www.calliopeconsulting.net