DSum Question

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

Which way does DSum calculate. I think it's down?
Example Down..

Iget = DSum("Amount*Tax",tblMoney")

Amount Tax
7.00 * .0825 = .5775
3.00 * .0825 = .2475
3.00 * .0825 = .2475

Iget = 1.07

I need to go accross......
Amount Tax
7.00 * .0825 = .5775 .58
3.00 * .0825 = .2475 .25
3.00 * .0825 = .2475 .25

Iget should be 1.08

How can I get DSum to go across, then down?
Thanks
DS
 
Perhaps you are confusing what Access does with the DSum() function and what
you might do if you were using Excel or some other spreadsheet.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff, I figured it out, I simply added Round inside the DSum.

Iget = DSum(Round(Amount*Tax,2))

All is groovy again!
Thanks
DS
 
Back
Top