Report that pulls from 2 different queries

[Bagels]

You all have helped me before...i'm struggling with this one.

I have a database that tracks customer returns/RMA's. I have a query that pulls all relevant return information based on the user's selection of customer and date range. It works fine. The report thats based on it also works fine.

I'm pulling in the shipping information from an external source, it's a make table query , it also works fine. I have a similar form that based on the user's selection and date range will display the total amount of parts shipped to that customer for that time frame.



What i'm trying to do is basically combine the two, so that I can say "there were 10 returns/failures for this customer over this time frame, and we shipped 5,000 parts to them during the same time" . So that I can calculate a PPM . But it's basically 2 queries, how can I have the date criteria apply to both queries at the same time, if that makes any sense at all.

[Salty Mariner]

Make a third query that combines the result of the two previous queries.

Do you have a common field that you can create a join on?

You need something to create a logical join on so the queries can relate. Customer Name perhaps? If it's external you might need to do something in a query with formulas to assure that you have the Customer Name spelled correctly so the join works. Or perhaps an order number. Your biggest hurdle will likely be creating a reliable logical join and because the shipping information is external you have no control over that data.

[Micron]

My interpretation of the requirement is a main form with customer details and a subform with returns. The subform might have 2 textboxes formatted as date data so that the built in calendar would pop up. One would be the From and the other the To date. Maybe that's not about what is being asked.

[orange]

Show the SQL of the working queries or a copy of the database with instructions.