question

Laser avatar image
Laser asked

Field showing #Deleted in Access 2010

I have an Access 2010 front end linking in to SQL Server backend tables. I have built a query in Access and one field shows #Deleted for Null values when the query is run, Non-Null values show the expected text. If I do a sort on another field and re-run the query the Null values are blank i.e. no more #Deleted in the field, the Non-Null values again show the text as expected. Does anybody have idead what causes this behaviour??
sql-server-2012access
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.