G Guest Apr 1, 2005 #1 How do you subtract one field from another? IE: subtracting field ones value from field threes value.
How do you subtract one field from another? IE: subtracting field ones value from field threes value.
A Arvin Meyer Apr 1, 2005 #2 Mistalina said: How do you subtract one field from another? IE: subtracting field ones value from field threes value. Click to expand... 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
Mistalina said: How do you subtract one field from another? IE: subtracting field ones value from field threes value. Click to expand... 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
