AnsweredAssumed Answered

Layout design (report?) for displaying / printing / emailing specific fields in records if a any of...

Question asked by mchancevet@gmail.com on Mar 27, 2014
Latest reply on Mar 31, 2014 by GuyStevens

Title

Layout design (report?) for displaying / printing / emailing specific fields in records if a any of a set of of conditions are met.

Post

     G'day,

     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..

      

John Smith 

     First Aid - 2/3/14

     Safety induction annual - 3/3/14

     Working with Children police check - 2/3/14

      

Joe Doe 

     Safety Induction Annual - 12/12/13

      

Jane Doe 

     First Aid - 12/11/13

     Perform CPR - 12/11/13

      

      

     Thanks for any help.

     Morgan

      

Outcomes