Frustrating Report, Need Help

[jollofrice]

I've made several posts about this in the last few weeks and am getting closer to the solution, but the deadline for my project was last Friday and this still needs to be done.

I have the following fields in a table named EventSchedule (compiled from normalized tables via append queries):

EventID (Table Primary Key)
LicensePlate (Primary Key for Vehicles)
VehicleName
EventName1
RepairID (Primary Key for Repairs)
RentalID (Primary Key for Rentals)
StartDate
EndDate

The table is a list of all events pertaining to my company's fleet. I need to generate a report for use by the sales staff and fleet manager that lists each vehicle as row headers, dates (will be input by form when report is run) as column headers, and then the name of the rental or repair (EventName1) for the vehicle at the row-column intersection. This row-column intersection also needs to display "IDLE" if the vehicle has no rental or repair or "CONFLICT" if there are two or more events on the same day.

I've tried everything I know how to do and several suggestions from other forum members, but still no dice and the boss is getting antsy. I'm pretty new to Access and am totally stuck, any help would be GREATLY appreciated.

 

[lark_tilly]

Do I understand that this table has a record for a vehicle only for the days where there is a rental or repair scheduled? If there are no rental/repairs scheduled on a vehicle for a particular day then nothing exists, correct?
So if the report was for a period that a car had no rentals/repairs scheduled it would not show up at all, correct?