error: You tried to assign the Null value to a variable that is not a Variant data type.

I don't have access to alter the tables, just create the reports, forms and queries.