- Joined
- May 26, 2011
- Messages
- 1
- Reaction score
- 0
I am seeking assistance with an attendance access database that I am working on. I am trying to create a query that displays the total number for each category (present, late, absent, absent – excused) that each student has per week.
Example:
Popcorn 248
Week of May 23, 2011
Monday (Absent)
Tuesday (Late)
Wednesday (Present)
Thursdays (Present)
Friday (Absent – Excuse)
The query would show that during the week of May, 23, 2011 Popcorn248 was:
Absent 1 time
Late 1 time
Present 2 times
Absent – Excuse 1 time
All of the fields have a “text” data type. However, each day of the week has the categories set up as a value list. I have tried using a crosstab query to display the categories and sum the total for each student accordingly, but I haven’t been successful. The crosstab query will only calculate each category for one day of the week. Can you tell me how I would accomplish displaying the information? I would only like to use one table and one query. Any suggestions are appreciated. Thank you for your time and help.
Example:
Popcorn 248
Week of May 23, 2011
Monday (Absent)
Tuesday (Late)
Wednesday (Present)
Thursdays (Present)
Friday (Absent – Excuse)
The query would show that during the week of May, 23, 2011 Popcorn248 was:
Absent 1 time
Late 1 time
Present 2 times
Absent – Excuse 1 time
All of the fields have a “text” data type. However, each day of the week has the categories set up as a value list. I have tried using a crosstab query to display the categories and sum the total for each student accordingly, but I haven’t been successful. The crosstab query will only calculate each category for one day of the week. Can you tell me how I would accomplish displaying the information? I would only like to use one table and one query. Any suggestions are appreciated. Thank you for your time and help.