Yet another dumb question

NavyJoe

Board Regular
Joined
Sep 14, 2004
Messages
63
I have 6 queries. All 6 query the same table. I tried create a report using all 6 queries, but I get some sort of connection error. I try and do it manually by creating a blank report and creating a black text box and changing it's control source. I fail. Is there something I'm doing wrong? Here is the info:

Table A:
Award Type:
Description:
Date:
Qty:

Query A:
Award Type: "jsam"
Description:
Date: Now()-7
Qty:

Query B - F are the exact same, except the Award Type. There are 6 different awards.

Please help me. I'm almost done.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
Why do you have 6 different queries?

Could you not just use 1 query and group by Award Type?

If this is to create a report then you could set group headers/properties to have the data for each individual Award Type on a seperate page.
 

NavyJoe

Board Regular
Joined
Sep 14, 2004
Messages
63
how do i divide the 6 up in the report? How do I sum each section up?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,114
Messages
5,570,269
Members
412,315
Latest member
ikokidko
Top