Hello, I am very limited to what I can do in access. What I can do is go into excel and import a query from access into excel. Then in excel I use it. The queries link directly with our software at work(this may be the case everywhere I'm not sure). My ultimate goes here is to export a new table query to an excel sheet that shows me the following information.
Product Name, Product Class, PostDate(the month the product was sold in), Quantity, Amount, Customer Number
OK, so if I go to Data - from microsoft query. I then choose MS Access Database. I find my database. Then in the Query Wizard where where I have available tables and columns on the left and columns in your query on the right. Here I am moving over two tables. The first table in our system is called MonthlySales This consists of Product Name, Product Class, PostDate, Quantity, and Amount. The second table I am moving over to the right is called CustomerFile, and this consists of Product Name and Customer Number.
I believe I need to move the 2nd one "CustomerFile" over because I need the customer numbers for the sales to come through to excel. So I do this and it tells me that they do not link together and it takes me to design view I believe it is. Here I join Product Name from "monthlysales" and make a joining arrow to Product Name from "customerfile".
I am then sorting by Product Name, then by customer number.
Then when I return information to excel here is the problem I am getting. It is listing the Product 24 times with one customer number. Each time it is a different month for the past 2 years. The sales per month are different do I thought I was successful. Then 24 rows down for the same product it lists 24 more rows for a different customer number and the quantity of sales it returns are the same as for the first customer.
It is doing this for all 20 customers we have for this product. It may be summing them all up between all customers I am not sure.
I know this is probably hard to understand what I am doing without seeing it.
I can provide whatever info necessary for any help. This may be too specific to our software and if so I apologize. Thank you
Bookmarks