Query result value #Deleted - Why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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