calculated fields from queries (1 Viewer)

[Dan]

I would like to know how to have calculated fields in my report from five different queries. I've tried a few things but I just can't seem to get it to work. They are just simple count fields and they work separatly on different reports but I can't get them on the same report...
thanks in advance

Dan

 

[cinnamoncw]

How are these reports connected? Are they all dealing with one field? You may need to combine all queries into one query before putting all onto a report, creating relationships with a common field.

 

[Dan]

It is just one report that I want to have 5 calculated fields appear on. It is a "report card" for a transit study that will look like this:
A B C D E
21 23 42 54 11

where the number fields are calculated from data entered into a main table. Access won't allow me to do any more than one of the calculated fields....

 

[Pat Hartman]

You can add 5 subreports. One for each count.
Or
You can create a union query and then crosstab the union query. Then use the crosstab as the report's recordset.