Multi Column Report for days of the week 1

[TimTDP]

In Access 2000 I have a query containing the fields Customer & VisitationDay. VisitationDay is Monday, Tuesday, Wednesday...

I am struggling to create a multi column report that shows the days of the week (VisitationDay) as the columns, with the appropriate Customer in the correct column. (Each customer has been allocated a VisitationDay)

How do I do this?

 

[dhookom]

I would store the visitation day as a number (day of week) however. You could create a crosstab query with [VisitationDay] as the Column Heading,"Schedule" as the Row Heading, and first of [Customer] as the Value. Set the column headings property to all of the possible values of VisitationDay.

Duane MS Access MVP