Thanks guys for your speedy responses. I reposted here as I initially thought I may have posted in the wrong forum, I do apologise for the multiple posts.
I am very new to access so I appreciate these questions may seem stupid!
I tried the first method of creating a query with the criteria...