I use a FM12 db to track student's work, and want to create a report which acts as a to do list, telling students which pieces of work they need to complete.
Fields have values entered as follows:
Work A (Field1)
Work is complete (Value1)
Needs finishing but not urgent (Value2)
Needs finishing as a priority (Value3)
What I want to report (ideally on an emailable PDF) is:
Work Urgently Needed:
Work that needs finishing:
Anyone got any suggestions?