Help please! I've done this before but for the life of me I can't remember how.
I have two tables which are joined by staff name: the Master Table includes staff details and the Absence Table includes absence details. The Master Table has been expanded to include a new row to represent each month of activity. I've already produced the total number of absences in the Master Table. Now I want to produce the reason given.
This forumala is wrong because you can't sum a text field, but it demonstrates what I'm trying to do.