Query Question

[Guest]

I have a monthly sales query and a YTD sales query. The problem I'm running into is getting a query that pulls all the records from the YTD query and everything from the monthly query as well. No matter what type of join I try to do their is nothing to link it to because a customer might not buy in a given month will always have sales in the YTD. Any help would be appreciated

 

[Steve Schapel]

George,

Do you have a field such as CustomeID in both the queries. It seems
to me that this should be the field that you use to join the two
existing queries to make your third query. This should be a Left
Join. If you are using the query design view, double-click on the
join line, and then select the option that says something like all
records from YTD and those matching from Monthly.

- Steve Schapel, Microsoft Access MVP