I have a query in Access 2007 that uses 2 linked SQL Server tables. Both tables have primary keys. They are joined by the primary key fields with a left join so the field from table 2 should be blank if there are no matching records. Instead of being blank, the fields say #Deleted (if there is a match, they show the field contents.) If I put a sort on the primary key field of Table 1 in Design View, no change. If, however, I right click on the blank area to bring up the Properties box and I put a sort there of the same field in the Order By and then run the query, the #Deleted goes away and becomes blank. The sort in Design View shows up in the SQL View, the sort in Properties does not.
I need to know what the sort in Properties is fixing, because I'm putting the query into my VB code and I can't use a Properties sort there.
Any ideas? Thanks in advance.