I have a table that has the following records that is used as a basis for data entry for:
Id WorkDate fkWorkerId Started Finished fkDetailId BaseHours THalfHours DTimeHours ALHours LoadingHours SickLeave OTJAllow OwnCarAllow TravelAllow
There can be anywhere between 1 and 15 entries for the same fkWorkerId for the same WorkDate so, to help ensure the accuracy of the data entry I would like to create a subform on the data entry screen that displays summary data (with only the total for each day by field) in the following format. This looks like a job for a CrossTab Query but from what I understand a CrossTab query requires a much more normalized structure with only one field being SUMmed. I can create a UNION query where each component relates to a different field and then use that query as a basis for a cross tab query but that seems like a very cumbersome solution. Is there an easier way?
Fri Sat Sun Mon Tue Wed Thu