Multiple Resources Problem

I've got a multiple resources calendar in an Access database. The calendar is used to schedule appointments with doctors. There is a separate column for each doctor.

I had everything up and running apparently fine with 3 columns on the calendar.

However, then I increased the number of columns to 5, and all of the appointments jumped to a different column. What I discovered was that the column that the appointment was showing up in is not consistent with the scheduleID. And the scheduleID changes depending on the number of columns.  (For example, with 5 columns on the calendar, appointments with scheduleID 1 show up on column 4, but with 4 columns, appointments with ScheduleID 1 show up on columns 3.)

Can anyone tell me what I would need to change so that ScheduleIDs are consistent with the calendar colunns -- SheduleID 4 is always in Column 4 for example.

Thanks!

Paul