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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

grand totals

Status
Not open for further replies.
abourg

abourg

Technical User
Jun 23, 2009
5
US
I have 4 tables with like data from different facilities.
I need to pull each like field for that month from each table and get a grand total to put in a report.
 
Sort by date Sort by votes
Based on the limited information you have provided (no table or field names or sample records) you should be able to use a union query as the record source for your report.

Duane
Hook'D on Access
MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Mike R
  • Locked
  • Question
Report header totals
Replies
1
Views
62
dhookom
dhookom
bcooler
  • Locked
  • Question
Summarizing data and reporting running totals by month
Replies
4
Views
79
bcooler
bcooler
RomeERome
  • Locked
  • Question
Dynamic Totals for a Crosstab Query 1
Replies
6
Views
70
dhookom
dhookom
misscrf
  • Locked
  • Question
Report totals? 1
Replies
5
Views
32
misscrf
misscrf
evr72
  • Locked
  • Question
Report Totals
Replies
1
Views
37
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top