Hi folks...I recently discovered this forum and I love it. I hope someone out there can make sense of my description and give me some guidance.
I am attempting to create a report based on a crosstab query. The report is a daily schedule of service calls for computer technicians. I would like to display times along the left side of the report per half hour of the working day, from 8:00AM to 6:00PM.
The technician's names appear across the top of the form. The grid is filled with customer names, Work Order numbers, phone numbers, etc.
My problem is that the underlying table ([Service Calls]) contains only dates and times that are actually scheduled.
My attempt to work through this problem included creating a table with one field containing all the available scheduling times from 8AM to 6PM, broken down into half-hour increments, and to include this field in the query as a Row Heading.
The query does display all the available times but of course any service calls scheduled for those times also appear, making it impossible for me to isolate those 'times' and force the report to show them as well.
I hope my explanation will serve here, and thanks in advance to anyone who can shed some light on this.
I am attempting to create a report based on a crosstab query. The report is a daily schedule of service calls for computer technicians. I would like to display times along the left side of the report per half hour of the working day, from 8:00AM to 6:00PM.
The technician's names appear across the top of the form. The grid is filled with customer names, Work Order numbers, phone numbers, etc.
My problem is that the underlying table ([Service Calls]) contains only dates and times that are actually scheduled.
My attempt to work through this problem included creating a table with one field containing all the available scheduling times from 8AM to 6PM, broken down into half-hour increments, and to include this field in the query as a Row Heading.
The query does display all the available times but of course any service calls scheduled for those times also appear, making it impossible for me to isolate those 'times' and force the report to show them as well.
I hope my explanation will serve here, and thanks in advance to anyone who can shed some light on this.