Hello,
As a newbie I need help with the following
I am trying to use MS access to collect Sales data via an ODBC connection and to output it in a certain fomat.
Basically I have done the following:
1. Create a maketable query to extract ALL sales data from 2008 into a table called Sales2009
2. I have made a query that groups for all customers the sales turnover and, sorts them from biggest to smallest and that saves the result in a table customer ranking
3. From the above table I only need the 150 biggest customers, so I manually delete the rest
4. I make a query that takes the customers from the customer ranking table and links it to the Sales 2009 table
5. Now I want to use the query in point 4 to group per customer per period the sales resulting in something like
customer ABC 2009-2009 02 € 25.000
customer ABC 2009-2009 08 € 12.000
customer DEF 2009-2009 01 € 150
customer DEF 2009-2009 02 € 1245
customer DEF 2009-2009 09 € 2500
Can anyone tell me how to do this ?
I am not know with SQL and am quite a newbie so be gentle
with me
As a newbie I need help with the following
I am trying to use MS access to collect Sales data via an ODBC connection and to output it in a certain fomat.
Basically I have done the following:
1. Create a maketable query to extract ALL sales data from 2008 into a table called Sales2009
2. I have made a query that groups for all customers the sales turnover and, sorts them from biggest to smallest and that saves the result in a table customer ranking
3. From the above table I only need the 150 biggest customers, so I manually delete the rest
4. I make a query that takes the customers from the customer ranking table and links it to the Sales 2009 table
5. Now I want to use the query in point 4 to group per customer per period the sales resulting in something like
customer ABC 2009-2009 02 € 25.000
customer ABC 2009-2009 08 € 12.000
customer DEF 2009-2009 01 € 150
customer DEF 2009-2009 02 € 1245
customer DEF 2009-2009 09 € 2500
Can anyone tell me how to do this ?
I am not know with SQL and am quite a newbie so be gentle
