I would like to create a report that lists the qualifications people have and when the qualification is due to expire.
This is the sort of thing I'm looking for. You enter todays date and the report returns results on the qualifications due to expire. I would also like to be able to view all qualifications and who has what regardless of there expiry date.
This was my attempt which is only showing one instance of each qualification. I know that the Power Boat Level 2 should show Lee Brooks & Brid Barrentt have this qualification.
More screen grabs to show setup of db.
Can anyone help me out please?