"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!
|