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

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

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

"Mark Soroka" Mark wrote in message
...
I am trying to subtract example Billed $ -Paid $ = Saving $

In a query:

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

Make sure that the two fields within the brackets are spelled properly.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Mark Soroka" wrote:

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