Yet another dumb question

[NavyJoe]

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.

 

[Norie]

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]

I need to do a total at the end, can I do that for each award type?

 

[Norie]

Yes.

 

[NavyJoe]

how do i divide the 6 up in the report? How do I sum each section up?