To get round the "invalid use of NULL" you can use var = "" & rs!field_name, but how do I do the equivilant with numbers? I have tried:
If rs!field_name <> Null Then
but the code never enters the "if" satement.
I don't really want to set the data to 0 either.
Thanks
Geoff ;)
------------------
