Cross-tab Query Report

  • Thread starter Thread starter Juan Schwartz
  • Start date Start date
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.
 
Yeah, I even filled that in, but it just seems to take FOREVER and
freezes up.
 
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)
 
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.
 
Back
Top