Simple Query

[asmith6]

Hi,

I know there is probably a simple solution to this but i cant seem to find it and now my deadline is running out!!

I am trying to add quarterly data to a yearly total table, so for instance i have for the year 2002, 4 seperate tables with the data in for each quarter, how can i add all the quarterly data to a new totals table??

 

[PHV]

Take a look at UNION query

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244