Hi Folks!
I am struggling with a cross tab query.

See attached: tblAssignment has 4 fields.
SchedDate, StartTime, EndTime, JobNum

Next Below is the result of the cross-tab query I want to be displayed.
This will help the Manager to see who is scheduled and who is not.
Your help will be appreiciated.

thanks,
SMS

You need to create a temporary table: Date,person,time,jobnum. Use code to loop thru starttime to endtime so you have 1 record for each hour. Then unite this with a table containing a blank record for each employee for each date for each hour.

Robert