DSum with multiple criteria

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

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!
Click to expand...

Try this:

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

Tom Lake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using DSUM to get running total on a filtered form 0
DSUM with variables 1
DSum Formula Problem 2
dsum with multiple criteria and decimals 0
Repost:DSum w/multiple criteria (Invalid Syntax) 7
Dsum Problem with date criteria 1
Access Dcount (multiple criteria) 3
Need help with the "dsum" function. 2

Top