I have a statement that says
if [field]=null then [field]=0
to change the field from a possible null to a 0
the field is a type currency and when it runs it will not change it to a 0
I have calculations that needs to work off the value of the field and they
will not work since it is a null. I could change the info later but it is in
a query and do not know how to do that later change.
--
Message posted via AccessMonster.c om
