Forum Discussion
IIf Function Access Query
New Query, Comparing 2 tables. Table 1 System Accounts Joined by: Company Name (Short Text) Table 2 Database Accounts Joined by: Company Name (Short Text) I would like to make sure the Acco...
Hi,
Maybe there is a difference you don't see easily, like trailing spaces or hidden special characters. This often happens e.g. when an import from a different system than Access is involved.
There are several methods to check for this. A simple test could be a criteria: "30-006778"
which you type in (not copy from one of the fields) and use in the query first for one AccountNr column then for the other. Does your example line/record always get returned?
Servus
Karl
************
Access News
Access DevCon