Urgent help needed

[de049]

Would you know how to count the number of times a letter(s) appear in a row on a report or query? For example, the output from the query is Surname,Name, and all 7 days of the week. For each of these days, a letter is displayed to specify wether the employee attended or was away from work. After the last column, my intention is to introduce a column that adds up and displays how many times that particualr letter appears on that row.

A new column would display the total number of P's for present were in that record.

So, if an employee attended all 7 days, the column for attended would display the value 7.
In another column, the number of A's for Absent will be totalle. And so on for all the possible outcomes.

Please help!!
'D'

 

[Rich@ITTC]

Hi de049

I think it might be better to split up this information into two tables - the employee and another table for attendance. In the attendance table you need only to store the employee ID and the date he/she attended. You can then in a query (or in a form or report) use the Count function to up how many times each employee attended within a period of a week ... and absences (if needed) would merely be = 7-Count([DaysAttended]).

HTH

Rich Gorvin