Union Query

J

JimP

I have multiple tables, Jan sales, Feb sales, etc.. Each table has multiple
orders and amounts for the same CustID.

Can I use a union query to combine the tables and sum the amounts by CustID
?
 
R

Rui

Sure

Create a union query and save it. then create a query with the first query
as the source and make it an aggregate query adding a sum(field) and grouping
by custID.

Rui
 
K

Klatuu

You can, but your basic design is flawed. You really should have only one
sales table with date field that identifies the date of the sale. You can
always use queries to pull data by year and month. It really makes
development in the rest of your application a lot easier. Like for your
forms, what do you have to do now, change the record source every month?
That is not a good way to do an application.
 

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

return primary key for record after append query 3
Removing a repeated words 0
Now asking for missing semicolon ???????? - Guidance please 4
Creating a Chart on form from selected data in query. 0
SUM in a UNION query 2
Comlex union query question 5
Concatenating Values 5
INSERT INTO Table, values derived in code from separating a name 1

Top