How do I create a day-of-the-week attendance record in Access 07?

  • Thread starter Thread starter jbondy
  • Start date Start date
J

jbondy

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.
 
Back
Top