DSum Question

[DS]

I have a DSum and I was wondering if this is the same or different?
They both seeem to gice the same answer.

DSum("(QTY*(Price+DisAmount))*Tax","tblTest")
Or
DSum("((QTY*Price)+(QTY*DisAmount))*Tax","tblTest")

Thanks
DS

 

[Daniel Pineault]

This is basic math.

(QTY*(Price+DisAmount))*Tax

by following the order of operation, and distribution principle you can
expand it as follows

(QTY*Price+QTY*DisAmount)*Tax
(QTY*Price*Tax+QTY*DisAmount*Tax)

For more info google math 'operation order', it is typically covered in
basic algebra (amongst others)
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[DS]

Thanks Daniel,
I was just trying to make sure nothing exploded down the road. I appreciate
the input.
DS