Creating a separate output for each counted record

[JAVILLA]

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:

WIRETYPE      BOX    COUNT
A                  1         3
B                   2         2

Now I want to make a cable list, so I want a query based on the above to spit out:

WIRETYPE      BOX    LABEL
A                  1        A-1
A                  1        A-2
A                  1        A-3
B                   2       B-1
B                   2       B-2

It doesn't have to autonumber, that could be done later in Excel, but it would extra super awesome if it did, especially if it number by cable type.

Any ideas?

Thanks in advance
Joe

 

[JAVILLA]

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 first table I listed with the TOTAL of each cable type, but not to generate a list with an entry for each cable in that total. So if there are 300 cables in a box, there would be 300 rows that are either black or autonumbered in my final query table.

 

[JAVILLA]

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 start with my first table (I should have called it table instead of query, apologies), only having the # of cables in each box, but not having a separate row for each. I want to auto generate the multiple rows from the original table.

Thanks so much for your help.

 

[wilpeter]

For the avid readers out there, you might not have been clear. You called the thread starter a counted record and talked about a sum query with the column titled COUNT. Surely, your Sum Query produced the SUM (not count) of the quantity column not the records?