Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Query

Status
Not open for further replies.
asmith6

asmith6

Technical User
Dec 21, 2004
4
GB
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??
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
10
Views
237
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
2K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
697
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
650
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
526
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top