SQL Queries

  • Thread starter Thread starter Chris Greco
  • Start date Start date
C

Chris Greco

I have 4 queries, Query1, Query2, Query3, and Query4.
each of them has the columns, ID,Date,Item,Cost

i would like to create a fifth query which would take any
record combine the records that have the same ID and date
and calculate the total cost.
any idea on how to do it? this is for VBA so I would
like to do it in SQL.
 
Dear Chris:

It would seem to make sense to make a UNION ALL of the 4 queries, then
proceed with that as the source for a Totals Query.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top