Reports

[Mick_Hart]

Im trying to place a cross tab table into a report.

However, i keep getting errors stating that the micorsoft jet engine cant find a certain column.

Does anyone know of a way of getting round this? Possibly by generating the report on the fly or something?

 

[Tanis]

How is the crosstab generated?

 

[Mick_Hart]

My table contains the following fields

Client - a list of our client names
Date - dates
Time - specific times
Round - time rounded to the nearest 15mins
Calls - number of calls

Ive just access's wizard for making the crosstab -

TRANSFORM Sum(Query.Calls) AS SumOfCalls
SELECT Query.Date, Query.Client, Sum(Query.Calls) AS [Total Of Calls]
FROM Query
GROUP BY Query.Date, Query.Client
PIVOT Query.Round;

This is the SQL used.