DSum with multiple criteria

  • Thread starter Thread starter epete367
  • Start date Start date
E

epete367

I am trying to use DSum on a form with multiple criteria:
DSum("[ExtendedTotal]","[Order Details Extended]",
"[Products.ProductID] = ______
I need it to look up and sum the records where the Product ID is any of
the following numbers 2,3,4,5,6,7,8,9,10,11,12,13
I have tried several possible ways but cannot get the function to work.
I either receive #ERROR or it adds incorrectly. Any suggestions? Thanks!
 
I am trying to use DSum on a form with multiple criteria:
DSum("[ExtendedTotal]","[Order Details Extended]",
"[Products.ProductID] = ______
I need it to look up and sum the records where the Product ID is any of
the following numbers 2,3,4,5,6,7,8,9,10,11,12,13
I have tried several possible ways but cannot get the function to work.
I either receive #ERROR or it adds incorrectly. Any suggestions? Thanks!
Click to expand...

Try this:

DSum("[ExtendedTotal]","[Order Details Extended]", "[ProductID] >= 2 and
[ProductID] <=13")

Tom Lake
 
Back
Top