Total two fields then subtract them

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
 
A

Al Campagna

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."
 

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

Split form 0
Insert Multiple Fields without Dialog closing between each... 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Creating a Search using a combo box and then creating a report. 4
MS Project Center-Autolink column fields 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Copy previous record into form field 0
Split records in a form 1

Top