DSum with multiple criteria

[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!

 

[Tom Lake]

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!

Try this:

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

Tom Lake