Query result value #Deleted - Why?

M

MonHas

Why is the value #Deleted being returned in my left-join query? I've tried
using NZ, Iif, Switch functions to eliminate null or zero values and same
results are retuned.
 
M

[MVP] S.Clark

When a query is executed, the data returned can be live. If after the data
is displayed, and it gets deleted, then Access will display #Deleted.

Without knowing more about the process used to get to the query, that's
about the best I can do for now.
 
Top