Calculated Report

[kr]

I work in a call center & receive a rpt w/all of our incoming calls per min
in 24hrs.
I want to use this info for one BIG rpt in access. current, i import the 1st
call rpt into access. then i'm able to create queries for specific info like
show All Calls, Unique Calls (Use the "First" calculation), and others. From
there, I can make rpts on each query and group the time field and hide
details to give precise info. What i would like is to be able to either
combine all of the rpts into 1 rpt or all of the queries into 1 rpt. Or just
make a report that would handle the calculations in the textboxes. This is
what i would like:
Total Unique Hangups Total - Unique
12AM
1AM
2AM
3AM
etc
HOW DO I DO THIS???? Currently, I can't get a textbox to calculate with
First aggregation for Unique.
Hope this is not too confusing cuz i am!!!

 

[KARL DEWEY]

You did not post your field names and datatype.
so, look up and try a crosstab query.

 

[kr]

okay, but i thought the crosstab will only do 3 columns. i need more than 3

 

[Duane Hookom]

A crosstab can derive nearly 255 columns. There may be a limit of 20 or 40 or
something Row Headings. This shouldn't be a problem.