how to pull data from more than one table in a report
Posted on 2015-01-25
I have a MS Access 2003 DB.... there are 2 tables and one form. The form is used to create an order and the products are selected from a drop down based on a 2nd table. TableCL The form's data is saved in another table, TableMain.
All is working with regards to the form and pulling data from the 2nd table to populate the form for the users selection. The form is saving to Table 1, no problem.
I am trying to make a report counting orders based a field in Table one... which I am able to do. The tricky part is that in this report, which is basically summing and counting total order I need one more compare and that is where my confusion lies. While I am able to apply my needed filter to get the report data, I need to filter it one more step using data based on Table 2... which is based on one of the data items of table 2. How can I parse though this 2nd table to find a criteria (MinorderQty) based on the data in table 1's order qty?
Please let me know if any clarification is needed, as I am sure it is. I am not a expert VBA programming especially when it comes to reports.