Crosstab Query - Weekly Days as Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably very simple but working too many hours and not sleeping has
affected my ability to perform simple tasks.

I have constructed a simple database for attendance of our employees. What
I require is to display that information via a cross tab query for their
attendance during each week.

The cross tab query would only show records for each employee for each day
Sat to Fri; this would be filtered so that only a weeks information is
displayed at any one time.

How do I assign the appropriate Sat to Fri days as the headers for the query?

Thanking you all in anticipation.

PMK
 
In the last line of the SQL use this --
PIVOT Format([YourDateField],"ddd") In ("Sat","Sun",
"Mon","Tue","Wed","Thr","Fri");
 
Back
Top