Report help with crosstab quary

[abourg8646 via AccessMonster.com]

I have a crosstab quary that with help from the MVPs its working perfect.
When I go to report wizard and try to pull up the crosstab quary then ther
are no fields to select. This quary is what about 5 or 6 reports will be
based on.

 

[Duane Hookom]

Have you enter the column headings?
How about sharing your SQL view?
How do you plan on handling the possibility of dynamic column headings?

 

[abourg8646 via AccessMonster.com]

I'm new at working with databases. How do you (sharing your SQL view)? What
are dynamic column headings? Here is a copy of my crosstab SQL.

PARAMETERS [Start date] DateTime, [End Date] DateTime;
TRANSFORM First([Employee Query].Schedule) AS FirstOfSchedule
SELECT [Employee Name], Shift, Post, [Time]
FROM [Employee Query]
WHERE [Date] Between [Start Date] And [End Date]
GROUP BY [Employee Name], Shift, Post, [Time]
PIVOT [Employee Query].[Date];

 

[Duane Hookom]

You just "shared your SQL view". Dynamic column headings mean the column
headings in your crosstab will change since the dates will change. You can
create a query with "static" relative dates using a solution like
http://www.tek-tips.com/faqs.cfm?fid=5466.

--
Duane Hookom
Microsoft Access MVP

I'm new at working with databases. How do you (sharing your SQL view)? What
are dynamic column headings? Here is a copy of my crosstab SQL.

PARAMETERS [Start date] DateTime, [End Date] DateTime;
TRANSFORM First([Employee Query].Schedule) AS FirstOfSchedule
SELECT [Employee Name], Shift, Post, [Time]
FROM [Employee Query]
WHERE [Date] Between [Start Date] And [End Date]
GROUP BY [Employee Name], Shift, Post, [Time]
PIVOT [Employee Query].[Date];

Have you enter the column headings?
How about sharing your SQL view?
How do you plan on handling the possibility of dynamic column headings?