Queries within Queries

[dfb89]

Hello all,



I am new to Access and am working on a database for my organization. I have the basics figured out (forms, tables, etc) but am wondering about queries. I have two queries set up, but need to set up two more. The first two are very basic, there are multiple criteria that have to be met and all of them must be met to be in that category. The last two, however, are more complex. Each have 10 criteria (which I know how to add to queries), however not all of them must be met to be in that category, just any combination. For example, 4 of 10 in the first, and 6 of 10 in the second. One result could meet criteria 1, 2, 5, 8 and another could meet 2, 4, 6, and 10 but both would be considered the same category. Is it possible in Access for Queries to draw from a specific set of data such as these 10 criteria but group them together even if they are different?

[aytee111]

The OR will need to be used. First, however, write down the query in words - I want to see all records that have x and y or a and b, something like that. Have your data showing on the screen while you do this and visually compare whether what you are writing down is going to work. Once you know what you want, translating it into a query becomes a simple matter.

[dfb89]

Thank you for your reply. I believe what I have to do is write a VBA code. Something along the lines of 'If criteria 1 or 2 or 3 all the way up to 10 is greater than or equal to 4 (or 6) then yes, the parameters have been met'.

[orange]

dfb89,
First, welcome to the forum!
As a new user of Access and database, here is a link to some database concepts and design info that you may find useful.

Good luck.