I'm trying to figure out how I can get access to output a separate row for each number in a count of records. i.e., I want a list of all cables to in a project so I can make labels.
So after a sum query I find a box has 3 of cable type A and 2 cables of type B.
So the query shows...