Avatar of Genius123
Flag for United States of America

asked on 

Access Query Multiple records


I need to make a query and I'm not sure how to go about it.

In the attached database, there is a table called Table1.
I need to make a query of that table that returns multiple records based on certain conditions.

If Quantity = 2, then return 2 records, but if Type = Apples, then return even 2 more records, one with the Thickness 1 value, and one with the Thickness 2 value.  

The end result of this query would like like the attached excel file.


Thanks for you help,
Microsoft AccessSQL

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon