yes. Was I suppose to put all of them in D0.

John Spencer wrote:
Are you putting just ONE of the expressions as the source for each
control? I know that may be a basic question, but I've seen people do
just that and then be confused about why something did not work.

'================================================ ====
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'================================================ ====

I copied the SQL and place that in my crosstab SQL. This displayed D6,D5nD4,
D3,D2,D1,D0 as column headers. I then went to reports and 1st I treid to copy
[quoted text clipped - 14 lines]
GROUP BY [Employee Name], Shift, Post, [Time]
PIVOT [Employee Query].[Date];

--
Arthur Bourgeois Jr

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200906/1