Using DSUM resetting upon next ID in dataset

[rpeare]

What does your domain equation say, looks like you are missing one of the three criteria I stated.

[ellisjo3]

I used your exact equation from above, sorted by item, date and order #.

[rpeare]

Then you have some other field in your query that is causing some duplication

For instance if I have

1/1/2013 A B C 500
1/1/2013 A B D 1000

in five different fields but I only perform my dcount on the first 3 fields I'll end up with the same number of 1500 if I do a dsum of the fifth column.

[ellisjo3]

Thanks a lot for your help.