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

------------------