How to show data in report related to label caption 1

[rccs1]

I am trying to set up a report where data is displayed only that is related to the label caption value for a weekly schedule report. eg.

Label Data
Room1 eventname
Room2 eventname
Room3 eventname

The data has been assigned to the rooms however, I need to repeat the room labels for each day of the week vertically.
Monday
Room1
Room2
Room3
Tuesday
Room1
Room2
Room3
Wednesday

So on.

 

[dhookom]

Your data:
[tt][blue]
Label Data
Room1 eventname
Room2 eventname
Room3 eventname[/blue][/tt]
doesn't have a day or date field. How can you derive days of the week?


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[rccs1]

Sorry, I did not state all the fields.
The fields are -
EventID
Date
Time
EventName
RoomName

I want to include all rooms even though there is no event in that room on that day.
eg
Week beginning ##/##/##
Monday
Room1 - eventname
Room2 - no event recorded
Room3 - eventname
Room4 - no event recorded

Tuesday
Room1 - eventname
Room2- eventname
Room3 - no event recorded

Hope this helps
Thanks
Room

 

[dhookom]

I would create a query of all combinations of rooms and dates. I generally keep a table of dates in my MDBs. This query might be:

SELECT TheDate, RoomName
FROM tblDates, tblRooms;

Then combine this query in another query with your un-named table. Join the date and RoomName fields and set the join properties to include all records from the date/room query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[rccs1]

Thanks dhookom.
Fixed my problem.Brillant thanks again