Hi, not sure if this should be in the table or report form.
I have a table that lists a large number of equipment. One line of equipment can be anywhere from 1 item to 300 items. Of those multiple items, I will have some that require serial numbers individually, thus the requirement to depict them as 25 single line items. But 300 wastebaskets can remain 300 wastebaskets on a single line.
If given the choice between the two (if only one rule exists) I would much rather have 300 individual lines for the wastebaskets, than have one single line for 25 serial numbered items.
I looked through the split string function, seems like a lot of code. I've used code once for a comparative report against two tables. Not sure I could do that again.
Bottom line is that I need to be able to produce a report that shows the eaches on a single line and another report that has a pivot table look that shows 300 wastebaskets and 25 Defibrillators on two lines.
If something similar has been brought up in the past, I can use the link, if not, any assistance would be greatly appreciated.
I have a table that lists a large number of equipment. One line of equipment can be anywhere from 1 item to 300 items. Of those multiple items, I will have some that require serial numbers individually, thus the requirement to depict them as 25 single line items. But 300 wastebaskets can remain 300 wastebaskets on a single line.
If given the choice between the two (if only one rule exists) I would much rather have 300 individual lines for the wastebaskets, than have one single line for 25 serial numbered items.
I looked through the split string function, seems like a lot of code. I've used code once for a comparative report against two tables. Not sure I could do that again.
Bottom line is that I need to be able to produce a report that shows the eaches on a single line and another report that has a pivot table look that shows 300 wastebaskets and 25 Defibrillators on two lines.
If something similar has been brought up in the past, I can use the link, if not, any assistance would be greatly appreciated.