View Single Post
  #1  
Old July 25th, 2007, 09:16 PM posted to microsoft.public.access.queries
PerryW
external usenet poster
 
Posts: 2
Default "nested" crosstabs?

Need help here! Have a PR database, with the following fields: EmpID,
EmpName, EmpElig, S/H, Date, Hours, Type.
I need a crosstab that may actually be a nested crosstab - dates for the
columns (every day in a given month) and under each day's column, columns for
"Type" - PR (production), NP (non-production), Hol, Vac, Sic, then hours
should land under each type. An employee could have hours in more than one
type for each day.

Any suggestions on this?
Thanks!