I am using Access 2000 and seeking help designing a query which will select records based on a partial, rather than a complete, match between fields.
I have two tables, A and B. A is essentially a complete listing of state highway projects in Arizona and contains the following fields:
Route...