Displaying Data Across

[Guest]

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.

 

[Guest]

THANX! I'm Trying this right now and I let you know how it looks.

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.

--
Duane Hookom
MS Access MVP

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!