I thought you wanted to create a report based on your crosstab. When/why did
your needs change to a form?

Did you actually try create column headings in your report?

I feel like I am aiming at a continuously moving target. Please find some
specifications and stick to them.

--
Duane Hookom
Microsoft Access MVP


"abourg8646 via AccessMonster.com" wrote:

I re-did my form and the record source is the crosstab. I then made a txt box.
I named it EndDate. What do I put into the contral source.

Duane Hookom wrote:
The form needs only one text box for the user to enter the ending date of the
report. The "6 more txt boxes" are on the report. One of my previous posts
was referencing the report and stated:
quoteIn the page header (or other section), you can add text boxes to use
as
column titles with control sources like:
=DateAdd("d",-0,Forms!frmDate!txtEndDate)
/quote
I made a form and called it date. I then added 6 more txt boxes and added the
-DateAdd statements to the control source under property. I'm probly doind
[quoted text clipped - 15 lines]
GROUP BY [Employee Name], Shift, Post, [Time]
PIVOT [Employee Query].[Date];

--
Arthur Bourgeois Jr

Message posted via http://www.accessmonster.com