Microsoft Access 2010 report from 2 queries
Posted on 2011-05-10
I have 2 tables called customers and chemistries. I need to create a report that prompts for a heat number (queries chemistries table,) customer ID (queries customers table) and also some other free form fields and then displays the corresponding info in one report.
I have created to separate queries with parameters and they work individually.
I have read that you need to use a form and generate a report containing sub reports how ever if i try and create 1 main report with 2 sub reports (one with chemistry data and the other with the simple customer query) it prompts me for the parameter information like 4 times.
Can anyone explain how to do this in easy terms.
1 sub report takes the inputted customer id and returns the customer name, address, zip
1 sub report takes the inputted heat number and returns chemistry compositions of an item
i need to lay out both these reports in a single report and only have the user input the parameters once.
I read something about using a form but i don't know how to link two un-related queries to a form and then have it generate a report.