A
ageorgesonster
Hello All
I am trying to run a query with a DSUM function to sum quantities in
one field based off the value of another field. I have an inventory
quantity that I would like to sum based on part numbers but I am having
trouble with the criteria. It should look something like this:
Autonumber Part# Quantity Sum
1 A 100 100
2 B 500 500
3 C 650 650
4 B 250 750
5 C 300 950
6 A 300 400
7 A 1000 1400
Is there something very simple that I am missing here?
I am trying to run a query with a DSUM function to sum quantities in
one field based off the value of another field. I have an inventory
quantity that I would like to sum based on part numbers but I am having
trouble with the criteria. It should look something like this:
Autonumber Part# Quantity Sum
1 A 100 100
2 B 500 500
3 C 650 650
4 B 250 750
5 C 300 950
6 A 300 400
7 A 1000 1400
Is there something very simple that I am missing here?