I am a beginning Access developer, and I have
taken 1 1/2 courses in VB. I know VB has the
answer to fix a problem, but I have not yet
figured out how to write it into Access.
My problem is that I have written an
application for my son–bookkeeping for his
business. I keep coming up with empty (null)
values, but when I use that field in a
calculation, the calculation won’t calculate.
I have found the NZ function, but I can’t
seem to get it into Access successfully.
If the null value is in a table, that’s OK as
I have figured out to use =0, not just the 0
as the default value,
but when a query created by joining two
queries tries to calculate something, the =0
in the original field does not fix the problem.
I need help with 1. writing the expression
and 2. where to put it!
Help! TIA!
