#deleted showing up in query

[thethack]

I have a query with several tables that when I run it one of the columns returns #deleted whenever there is no data in that field of the underlying table. I have removed the table completely and then I get the #deleted response in another column from a different table.

I did a search on Microsoft's Knowledge base and it recommended running the latest Jet service pak but I still get the problem.

Any ideas of how I can get rid of this? I run Windows 2000 Professional and Access 2000.

Thanks for any information.

 

[aleb]

Usually this "deleted" thing happens when someone deletes the data while you have the same record pulled on your screen.

 

[thethack]

Thanks for the thought Aleb but that is not the case as no one else had access to the data at the time. Oddly enough it will show up in different data fields. Another field in the query that I sat up an IIF function in treats the value of the field with the #Deleted data as null.