B
Brennan
hello all,
I am currently using the Nz function to populate the null values with zeros
so that I can build calculated fields in queries. The NZ function returns a
text value, and when I try to add those values it treats them as text. For
example:
Field1: nz([Rev],0)
Field2: nz([cost],0)
Margin: [Field1]-[Field2]
If the there was a null value in fields 1 and 2 the margin calculation
returns two zeros or "00."
Is there another function that I should be using? Is there a way to change
the formats so that field1=1 and field2 =2 would create a margin number of -1
not 12? I have tried changing the format of the field to Standard or general
number and that does not solve the problem.
Thanks for any help!
Brennan
I am currently using the Nz function to populate the null values with zeros
so that I can build calculated fields in queries. The NZ function returns a
text value, and when I try to add those values it treats them as text. For
example:
Field1: nz([Rev],0)
Field2: nz([cost],0)
Margin: [Field1]-[Field2]
If the there was a null value in fields 1 and 2 the margin calculation
returns two zeros or "00."
Is there another function that I should be using? Is there a way to change
the formats so that field1=1 and field2 =2 would create a margin number of -1
not 12? I have tried changing the format of the field to Standard or general
number and that does not solve the problem.
Thanks for any help!
Brennan