Remove #Error in query or Report (1 Viewer)

syedadnan

Access Lover
Local time
Today, 21:03
Joined
Mar 27, 2013
Messages
315
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

Wino Moderator
Staff member
Local time
Today, 10:03
Joined
Aug 30, 2003
Messages
36,118
Try wrapping it in the Nz() function.
 

plog

Banishment Pending
Local time
Today, 12:03
Joined
May 11, 2011
Messages
11,611
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

Access Lover
Local time
Today, 21:03
Joined
Mar 27, 2013
Messages
315
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

Banishment Pending
Local time
Today, 12:03
Joined
May 11, 2011
Messages
11,611
Yes, post the SQL of your query.
 

Users who are viewing this thread

Top Bottom