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.
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.