Users on the DB I've set up input a few different kinds of data. there's a form for items received, one for amendments, one for non conformities etc.
A report on each of these is produced for the previous month ie report presented in April is on March's figures.
I've set up the queries using...