I understand, and it would make sense to do that, but unfortuantely these are the criteria I've been asked to stick too so I think I should at least create the query and then they can choose whether to use it or not.
Thanks.
I'm having trouble trying to sort out a validation rule for a database.
I want students who have passed after two years to be deleted off the database and to do this I'm running a delete query, however I can't seem to get the validation rule right which will delete them off through the query. I...