Cross-tab Query Report

J

Juan Schwartz

How can I include a crosstab query in a report?

I've tried importing it via the report wizard, but that seems to just
to causes Access' process to stop responding.

The column headings will always be static... intervals... 00:00, 00:30,
01:00, etc.
 
D

Duane Hookom

Have you set the column headings property in the Crosstab query design view?
 
J

Juan Schwartz

Yeah, I even filled that in, but it just seems to take FOREVER and
freezes up.
 
J

Juan Schwartz

It recreated the query from scratch minding the Column Headings
option... It now says I have too many fields selected... I have 00:00 -
23:30 which is 48 and 2 other fields (date/subject)
 
D

Duane Hookom

Please provide the SQL view of your crosstab. I would never derive column
headings from time (or date) values. I try to use relative dates/times or
something similar.
 
Top