Selecting Distinct Value of multiple criteria

[RussOSU]

My issue here is the way our data is stored and retrieved in our system yet making it do what I want. Currently we have a serial number that has many options. These options each populate a table with the serial number and a single option per row. What I am wanting to do is to filter the Serial numbers based of the options. I know I can filter the serials to get the unique ones using DISTINCT however I am not sure how I can query two options at one time like I am looking for. If the options were set where the serial was the key field and the options were in columns this would be easy. I could create a query-to-table for one option and then another query of that new table however with the number of options and queries this would not be an appropriate method.

- Russ

 

[GingerR]

Please list your table structure (fields), your current query, what your current (undesired) query results are and what your desired results are. Thanks.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244