Displaying Data Across

[AccessGal]

My data needs to look like this:
ACROSS THE PAGE
Job/Sub No
Pay Item/Cost Code
Mon – Sun (hours worked under each day with Reg Hours/Overtime/Double Time)
Total Column

At the bottom of the page fields need to sum All billablehours in a field;
All billableOT in a field and All billableDT in a field for each day of the
week worked.

? How do I get the hours worked under the days of the week going across the
report??
My query is; EmployeeNo; Job No; DateWorked; Costcode; BillableHours;
BillableOT; BillabeDT

Thanx!

 

[Duane Hookom]

You can create a crosstab query that creates columns based on
Weekday([DateWorked]) to get the values summed under the correct days. There
is an article on creating multi-valued crosstabs at
http://www.access.hookom.net/ArtMultiValueXtab.htm.