Problem doing simple math function with three fields

G

Guest

I have a query with three currency fields I am tying to do the following
calculation

field1 +field2 - field3 If I have values in all three fields it works
fine.
field 2 is an adjustment field and can be positive or negative number.
If there is no value in field 2 which is not required I do not get a result.

Any help would be greaty appreciated.

Using Access 2003
 
M

MGFoster

Flanman said:
I have a query with three currency fields I am tying to do the following
calculation

field1 +field2 - field3 If I have values in all three fields it works
fine.
field 2 is an adjustment field and can be positive or negative number.
If there is no value in field 2 which is not required I do not get a result.

Any help would be greaty appreciated.

Using Access 2003
Click to expand...


Nz(field1)+Nz(field2)-Nz(field3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Function Within A Query 6
DSum update query with multiple fields 0
Shift several columns in table 4
Calculating on Null Fields 1
Group By, Max and Min 2
Is this impossible? 4
access form 1
how query multiple fields into one field? 1

Top