Total two fields then subtract them

  • Thread starter Thread starter Dan Lavish
  • Start date Start date
D

Dan Lavish

I have two fields in a form base on a table. I need a control that
adds all the records together for each field then subtracts one total
from the other. Any help would be nice
 
Dan,
A bit more detail would be helpful... or perhaps some sample values...
Given Field1 and Field2, with numeric values.
= DSum("[Field1]","tblYourTable") - DSum("[Field2]",tblYourTable)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top