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.