Subtracting with nulls 1

[MICKI0220]

I have a query that uses two tables. The join takes all the records on the first table with only those that match in the second table. I then subtract a field called negative carryover from the other. I am trying to get a new negative carryover. If there was not a matching record in the second table, then I get a blank negative carryover instead of what the negative balance was in the first table. How do I get this to show up?

 

[PWise]

use the nz function
table1.[negative carryover]-nz(table2.[negative carryover]-,0)

 

[Kiwiman]

Howzit

Try

[field1]-nz(field2],0)

Take it Easy
Man with one chopstick go hungry

 

[Kiwiman]

Hey pwize - sorry you musta posted while I was typing. Cheers

a little typo in mine

[field1]-nz([field2],0)

Take it Easy
Man with one chopstick go hungry

 

[MICKI0220]

Thank you, that did it.