C
ChuckW
Hi,
I have a table with three fields: ItemNumber,ItemName and
Quantity. My Item Numbers are either a number 1 through
13 or an alphanumeric number 1T through 13T. Item 1 and
1T are the same thing as is all items with corresponding
Ts (13 and 13T are the same thing). In the Item Name
field, all items with T are the same as those without
except they have the word "Taxable" after the item name.
For instance, Item 1 is Value Pack and 1T is Value Pack
Taxable.
What I want to do is to combine the items without the Ts
with those with the Ts and sum the quantity. So I want
to combine all 1s and 1Ts together with the combined
quantity sum. The Item name should exclude the word
taxable. The final data would have:
ItemNumber ItemName QTY
1 Value Pack 300
Can anyone help?
Thanks,
Chuck
I have a table with three fields: ItemNumber,ItemName and
Quantity. My Item Numbers are either a number 1 through
13 or an alphanumeric number 1T through 13T. Item 1 and
1T are the same thing as is all items with corresponding
Ts (13 and 13T are the same thing). In the Item Name
field, all items with T are the same as those without
except they have the word "Taxable" after the item name.
For instance, Item 1 is Value Pack and 1T is Value Pack
Taxable.
What I want to do is to combine the items without the Ts
with those with the Ts and sum the quantity. So I want
to combine all 1s and 1Ts together with the combined
quantity sum. The Item name should exclude the word
taxable. The final data would have:
ItemNumber ItemName QTY
1 Value Pack 300
Can anyone help?
Thanks,
Chuck