Query Problem

G

Guest

I have 3 tables. The first is a list of customers with the fields CUSTOMER NO
and CUSTOMER CITY. The second table is a list of 2003 sales with the fields
CUSTOMER NO and SALES. The third table has the same field as the second
table. How do I create a query with CUSTOMER NO CUSTOMER CITY SALES
(from the second table) and SALES (from the third table)? Not all customers
have sales, some have sales in both years, some have in one of the years but
not both years.
 
G

Guest

sound like a union query. look up union queries in access
help. they are SQL specific.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update subquery 1
To reconstruct a data table 1
matching records 3
Sum with a null value 2
Computing total sales with a query 2
Simple way to combine unmatched and matched records in one query? 6
Query Not working with newly imported table 1
Sort Cust list into 80/15/5 Groups 4

Top