I am wanting to track attendance based on the day-of-the-week, using worker 
ID found in as Access 2007 database.

assuming you have the day field accepting a date (3/3/08) create a query 
based on the table you are trending. this way when you get a lot of data, 
you can set parameters to make your check between dates.

now generate a report and group by the date field and change the grouping 
options to date by Day.

I don't have 07, so I am assuming the wizard is the same. but if not, here 
is the formula for your date group header:

=Format$([date],"Long Date",0,0) -- "This shows Monday March 3 2008, 
Tues....."


but



if you have the day field with the day of the week in a drop down select 
format and the actual date in another field do this:

assuming you want to either see who is there/gone on Mon, Tues, etc.

generate the query based on the table you are trending, then gen the report 
and group by week day (what ever you have the field named)

this will, if you don't filter for between between dates for like one week, 
it will result in the following:

Mon
  Wk 1      3 mar 08
   Wk 2      3 mar 08
    Wk 3      3 mar 08
    Wk 1     10 Mar 08
    Wk 2     10 Mar 08
    Wk 1     17 Mar 08
Tues
    Wk 1     4 mar 08

and so on and on.



"jbondy" <jbondy@discussions.microsoft.com> wrote in message 
news:1A14FBB0-CD56-4FB3-9068-F3A9C1092EB7@microsoft.com...
>I am wanting to track attendance based on the day-of-the-week, using worker
> ID found in as Access 2007 database.