Remove #Error in query or Report (1 Viewer)

[syedadnan]

Regards,

I have a query with dlookup and dsum formulas now if the fields for the search of dsum or dlookup are null then it returns #error ... how to remove it in query or report

 

[pbaldy]

Try wrapping it in the Nz() function.

 

[plog]

I have a query with dlookup

That means you're doing something wrong. Through the magic of a JOIN there should be no reason to have a DLookup in a query. Same goes for DSums. I really think you need to rework your query.

 

[syedadnan]

That means you're doing something wrong. Through the magic of a JOIN there should be no reason to have a DLookup in a query. Same goes for DSums. I really think you need to rework your query.

I am not such strong in queries .. could you please explain how to do it ?

 

[plog]

Yes, post the SQL of your query.