how match blanks in number field?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

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
 
Hi Ian

Take a look at the NZ() Function in the help file.
NZ(Field1,0) would evaluate to 0 rather than null
 
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.
 
Back
Top