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.