Layout design (report?) for displaying / printing / emailing specific fields in records if a any of a set of of conditions are met.
I am having difficulty conceptualizing a structure/design for a layout. I am on FM adv. 13. My DB records personnel (teaching staff) and I need to generate reports that list names of staff if they are out of date on first Aid training and a long list of other expiry date based conditions. I need the layout to display only those fields that are actually out of date and the name of the staff member.
My data (expiry dates, names, contact details) is all held in one table.I can't see how to structure the layout . I think it will be a list. I seem to have real difficulty getting my head around finds and found sets in layouts
a rough example follows..
First Aid - 2/3/14
Safety induction annual - 3/3/14
Working with Children police check - 2/3/14
Safety Induction Annual - 12/12/13
First Aid - 12/11/13
Perform CPR - 12/11/13
Thanks for any help.