Saturday, February 25, 2012

Calendar Report Layout Help

Hello

I need to create something like the following table:

MON TUE WED THU FRI SAT SUN

01/01/07 02/01/07 03/01/07 04/01/07 05/01/07 06/01/07 07/01/07

Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field

08/01/07 09/01/07 10/01/07 11/01/07 12/01/07 13/01/07 14/01/07

Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field

The user would enter the start date, in this case the 1st Jan 07 and then this would populate a table. This seems like it should be so simple but I can't work it out, can anyone help please?

Cheers

I sorted it using a cross tab query.

No comments:

Post a Comment