Chances are that your report's query is using a function that is "erroring"
because one of the arguments for that function contains a Null value, and
the function will not properly handle a Null.
Most likely one of your data fields has a Null value in it, and that data
field is being used in a function that cannot accept Null as an argument.

Signature
Ken Snell
<MS ACCESS MVP>
> hi my invoice report worked absolutely fine
>
[quoted text clipped - 4 lines]
> pls help
> thankx in advance