substracting in query

  • Thread starter Thread starter peljo via AccessMonster.com
  • Start date Start date
P

peljo via AccessMonster.com

I have a calculated field in my query where one sum is substracted from
another.However when there is nothing in the second field, the result is
also nothing, while i want to preserve the first value
my expression in the query is : Diff: [imported]-[exported]

if i have 100 items imported and nothing exported, the result is nothing,
while i want to be 100
How could i achieve that ?
 
hi,
I have a calculated field in my query where one sum is substracted from
another.However when there is nothing in the second field, the result is
also nothing, while i want to preserve the first value
my expression in the query is : Diff: [imported]-[exported]
Click to expand...
Use the Nz() function:

Diff: Nz([imported],0) - Nz([exported],0)



mfG
--> stefan <--
 
Back
Top