Calculated field multiple table

[sash19]

Hey, so I have 2 tables, One for attendance which takes the attendance of an employee in accordance to date & time and another for Attendance Sum which is the total number of days the employee was present in a month. So, I want that whenever someone makes a new record for the attendance of the employee, the value of Attendance Sum gets increased by 1 for the specific month where the employee was present. Both are different tables linked with the Employee ID. Is this possible? If yes, then how?

[pbaldy]

I personally wouldn't try to save it. A totals query can easily give you the total days per employee per month. If you insist on it, you could run code in the after insert event of the attendance table executing an update query or SQL.

[Robyn_P]

Do you need two tables for this? Could you not just create a query to count the attendance in a specific month in the main attendance table (assuming there's a separate record for each attendance)?