It is still leaving D6,D5,D4,D3,D2,D1,D0 as column manes. When I put =DateAdd
statement then I get columns of #Name?.

John Spencer wrote:
NO, just one in each of the controls.

And you do need the equal sign.

You need to add controls in the report that replace the labels for your
date columns and set the control source for each new control to a
variation of the following:
=DateAdd("d",-6,Forms!frmDate!txtEndDate)

If that does not work then you need to tell us what you mean by does not
work. Are you getting an error value, the wrong information, no
information? If an error what exactly does the error say? If the wrong
value, what value are you getting and why is it wrong.

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

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

[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