Access Report Format Question

[dvery]

Hi,
I am tracking vacations for my department using a calendar in Microsoft Access. In my current report, a manager selects dates for the month he/she wishes to view. The report format I currently have is:

John Smith 11/1/01 Vacation
Bill Jones 11/2/01 Vacation
Bill Jones 11/3/01 Holiday
Bob Brown 11/30/01 Sick Day

I would like the format of the report to be this:

11/1/01 11/2/01 11/3/01 11/30/01
John Smith Vacation
Bill Jones Vacation Holiday
Bob Brown Sick Day

A crosstab query will not work because the dates and vacations for each employee will change as vacation days are added, deleted, changed, etc and the manager will wish to view different months of the year.

Is there an easy way to change the format of this report? Any help would be GREATLY appreciated. Thank you in advance.

 

[JimHorton]

dvery,
Check my reply to thread181-160728
It's not a specific solution to your particular set of data but it should point you in the right direction.
--Jim

 

[yarub]

Dvery,
I am having the same problem that you had sometime back about creating report from Xtab query, I am also trying to Create a crosstab report with dynamic column headings.

how did you solve this problem?

thanks.

Tanvir