I am trying to understand what setting is different !

With my Office development computer, the result of a filtered view contains all records meeting the filter requirement. i.e. with a filter of the project ID of say '000504', the result contains all records containing 000504.01, 000504.02 etc .

With my Clients computer, zero records are obtained. and it is necessary to identify the all possible proj_id combinations within the SQL query filter variable.

Any ideas

Peter F Lee