Rather than define every query that your users might require, why not let your users make up their queries as they need them. Russell Sinclair discusses how to create a simplified query interface for Access users.
You can find the article for this here
Note: For those of you that wonder why we dont post the actual download files with these articles, I must be upfront and explain that the downloads only come with the Smart Access collections. This is how we pay for the hours that are required to get these articles out to you. And to those of you that have purchased the Smart Access collections already, the fantastic initial response has inspired us to start building this comprehensive new website.