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

Populating report controls (text boxes) w/ queries

Status
Not open for further replies.
gnatsnyder

gnatsnyder

Technical User
Dec 3, 2003
7
US
I am new to all of this and am really stumped. I have a report that needs to summarize a database based on several criteria. For example: query Q1 filters the table on criteria a, b, c, and d. This results in a few records but are are reduced to 1 row by the sum of column d. Q2 does the same thing except criteria b is now e. Q3 is the sum of both Q1.d and Q2.d. Here is my problem. I must repeat this process 160 times and include the results of the queries in 1 report. How do I do this?

Any suggestions would be most welcome!
 
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
552
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
527
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
638
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
501
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
537
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top