7-column report that skips columns with no data

[joeselch]

I have a 7-column report that lists the events associated with each of the 7 days of the week. This works fine, when there is an event on each of the 7 days; but... when there are events on only (say) 4 days of the week, then only the first 4 columns are used.

Ideally, each of the 7 columns should represent the 7 days of the week (Mon - Sun), with Monday always in the 1st column, Tuesday always in the 2nd column, etc. If there is no event on a particular day, then the column for that day should be skipped.

Does anyone know how this might be done?
I'm imagining that it might take a union query between the user-defined report record set and set of calendar days spanning the user-entered start and end dates (with its start date set to ensure a Monday, in case the user-entered start date is a day other than Monday).

 

[Hassan]

Actually I have quite similar problem. I have 5 column report also representing five days of the week. In each day there may be 4 events.

If each day has thoes four events then everything is ok, but as soon as there are less than four events, events from the next day are attached to the end of previous day.

What I want is to make it work so when certain event drops out it's place on report is printed out as empty cell.

Btw, each event is registered in table and each event has it's date.

I am junior access user and I am learning from samples, but I can't find any samples for that. And I am pretty sure that there will be some code writing necessary.

Does anyone know how to deal with that?

Thank you in advance.

 

[Fornatian]

I don't know the specifics but I would wager that the answer lies in a CrossTab query if that's any help.

Sorry I can't be more specific.