how match blanks in number field?

[Ian Elliott]

Thanks for any help. I have a table and a query that I input into an Excel
spreadsheet, match up a couple of fields, subtract account value if they
match, don't if they don't, and put back into Access. I would like do this in
Access if possible, since taking into Excel seems kinda silly when this looks
like something Access could do. I could do by hand in Excel, there's only
about 200 records, but it would take an hour or so, and I might make mistakes.
Now here's the problem when I tried to make this query: one of the fields I
tie to each other is a number field, but doesn't have a default value of
zero, and is blank for a lot of records. The query won't match these up it
seems.
I figure the query also has to have a join properties that is special too.
If anyone could help, I would appreciate it greatly!
Thanks

 

[kc-mass]

Hi Ian

Take a look at the NZ() Function in the help file.
NZ(Field1,0) would evaluate to 0 rather than null

 

[KARL DEWEY]

It seems to me that more often than not you need the zero, so why not set
default to 0 (zero) and run an update on the field.
Then use IIF when you do not want to display the zero.