Can anyone explain how I might be able to return a numbers of records based on
the sum of a quantity in a field in the same table? (After I read that it
sounds even confusing to me).
Let me explain. I have records like this,
Part# Qty
1254 5
1414 2
14758 1
1254 6
1024 3
1254 1
Now if I did a query like this
Select Part#, Sum(Qty) From table1 Group By Part# Where Part#=1254
I would expect my results to look like this
Part# Sum(Qty)
1254 12
But what I really want is this
Part#
1254
1254
1254
1254
1254
12541254
1254
12541254
1254
1254
So 12 virtual records for the count of the records returned from the Sum()
Can someone help me with this?
- Thanks