Date Header and Layout Questions

B

Ben

I have 1 table with headings of:
TaskType
SiteName
StartDate
EndDate

On a report, I want the header to show every Monday's date going
horizontally displaying every Monday from now until 2 years from now. Then I
want the Vertical column to be the TaskType. Within the report I want the
SiteName to be identified in both the Monday's Date Column and the TaskType
Column.

For example, 30-Nov-09 (Monday) TaskType-DSR SiteName - DC. The date being
on the header, the TaskType on each row and the SiteName cross referenced
between them.

Does this make any sense?

Thanks
Ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DateAdd not working correctly. Need fast help!! 1
Calculate Date automatically in word 2007 1
Setting a date in the Header 2
Turning page header on and off 5
Display billing month based on start date and end date 5
Highlight textbox based on date 2
Report and subreport w/Criteria Parameters issues 2
Issues grouping criteria toghether 0

Top