Subtracting one field from another

Mistalina · Apr 1, 2005

How do you subtract one field from another? IE: subtracting field ones value
from field threes value.

Arvin Meyer · Apr 1, 2005

Mistalina said:
How do you subtract one field from another? IE: subtracting field ones value
from field threes value.

In a query, build a column:

Result: [Field3]-[Field1]

You may also want to check for and replace Nulls:

Result: NZ([Field3],0)-NZ([Field1],0)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access