3 Letter Search in Access

[RCJ2]

I'm trying to do a match with two different tables. I would like to do the match against names that start with the same 3 letters. Is there anyway I could do this?

ie: "WIL"liam Clinton could match with WILL SMITH or WILMA FLINTSTONE.

Any help would be GREATLY appreciated! Thanks

 

[spazmonkey]

There are several ways to do this.

One way would be to use a union query to join the two tables or some fields from the two tables. The field names would have to be identical.

Create a query for both.

Copy the SQL from both and paste it into a new query. One after the other.

Between the two SQL statements and on a seperate line if possible insert the word UNION.

You will then have one table to search through.


Select the Text in the Field if you like then choose Records|Filter|Filter By Selection.

Hope this helps