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
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.
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.