No, sorry, perhaps I wasn't clear.
The user enters the number of each cable type as a first step. The reason I need to sum is that sometimes the same cable type is associated with a different connector (not important for this query).
So for this, let's pretend that's not happening. We...
I'm not sure what you mean. I'm trying to autogenerate a list where there is one entry for each wire that appears in each box. This list would be sorted first by wiretype, then by box. There would be either a blank or an auto-label column next to that.
I can only get Access to generate the...
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...