Crosstab query

[RA]

I collect call data, by customer, by time of day. For
example XYZ Co. called 10 times this week,(3)@1PM, (1)@
9AM, (6)@4:30PM

I want to pull a report that shows all customers and the
calls recieved in all time periods. I used the wizard to
build my intial query and while the format is correct, the
data is wrong. I have the same numbers for all customers
in all timeperiods. I'm sure I'm missing one step, any
ideas?

RA

 

[Duane Hookom]

Can you share
-some sample data (with field names)
-your current SQL view of the Crosstab
-what you actually want for results based on the sample data