"invalid use of null"

[Guest]

I'm trying to pull up my receivables aging report in Access, and it tells me
"invalid use of null."

What can I do to fix this thing?

 

[Allen Browne]

First step is to understand what caused it.

See:
Common errors with Null
at:
http://members.iinet.net.au/~allenbrowne/casu-12.html

 

[Peter R. Fletcher]

This usually means that a record contains one or more empty (Null)
fields and the contents of (one of) these fields is being specified as
an argument to a Function that expects a specific Type (i.e. not an
Object or Variant, which can be Null).

I'm trying to pull up my receivables aging report in Access, and it tells me
"invalid use of null."

What can I do to fix this thing?

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher