Hi Everyone,
I need a recommondation on where to start. I have 2 tables. Table 1 is based with Customers, Product Lines and Amount Sold. Table 2 is based with Customers, and Machines.
Now both tables have customers listed multiple times...(meaning they can have purchased several different product lines and also own several machines)
Now I have been asked to compile a report that will pivot out the product lines grouped by customer but also list the machines that they own.
I have been monkeying around with queries but keep coming back to the tables as my queries are not coming out correctly.
so...my question is how would recommend cleaning these tables up so write a query.
Let me know if any code examples would help.
Sue
I need a recommondation on where to start. I have 2 tables. Table 1 is based with Customers, Product Lines and Amount Sold. Table 2 is based with Customers, and Machines.
Now both tables have customers listed multiple times...(meaning they can have purchased several different product lines and also own several machines)
Now I have been asked to compile a report that will pivot out the product lines grouped by customer but also list the machines that they own.
I have been monkeying around with queries but keep coming back to the tables as my queries are not coming out correctly.
so...my question is how would recommend cleaning these tables up so write a query.
Let me know if any code examples would help.
Sue