How do you create a formula subtracting 1 field into a 2nd field

[Mark Soroka]

I am trying to subtract example Billed $ -Paid $ = Saving $

 

[Al Campagna]

Mark,
First, change the names of those fields.

Avoid spaces in names. (if you do have a name with spaces,
make sure you always bracket... ex. [Billed Amount])
When in doubt... bracket.

Avoid Access reserved words, and special characters. The $ designates
a string in Access, and should be avoided used in object names.

[Billed] - [Paid] = [Saving]
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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

 

[Jerry Whittle]

In a query:

Saving $: [Billed $] - [Paid $]

Make sure that the two fields within the brackets are spelled properly.