Hi thanks very much for the speedy reply.
It's a bit difficult to post an example row as all of the relevant information is contained in different tables. We have been inputting data via a form. I have attached a doc that explains where the various pieces of info are in the form and the...
Hello. I'm quite new to Access and have inherited a database from a colleague. It is a database of references from which we have extracted pesticide active ingredient, pest species and crop species using forms. I am trying to create a query that will allow us to search and return unique active...