Counts on fields

[kbreiss]

In my table I have a date field and three different two position numeric fields called first, second and third. Currently I have 3 different queries that counts and groups each field. For example in the "First Query" data looks like

First Qnty
02 10
11 5
07 6 , etc.

The "Second Query" and "Third Query" are the same format.

I'm wanting to create a report that lists the results from the "First Query", "Second Query" and "Third Query"

So I guess I need to create a query so I can use it as my recordsource for my report that looks something similiar to this...

First Qnty1 Second Qnty2 Third Qnty3
02 10 09 5 18 2
11 5 12 6 19 9
01 6 17 5 12 4

Does anybody have any ideas so I can get all these results into one report?

Thanks,
Kacy
________
Reinsurance Dicussion

 

[kbreiss]

Thought I had it figured out, but still WRONG.
________
Opa