I'm trying to create a query from 2 tables that will match the names from one table to the address of another. The one table has first initial and last name but the other table has first name and last name. I want the query to select the first name from the one table that begins with first first-name initial from the other table. The query I created was the following: SELECT([First Name]FROM[No blanks FAA Airman List](WHERE([First Name]FROM[No blanks FAA Airman List]BEGINS WITH [First Initial]FROM [USAir Pilots])). I keep getting a syntax error message. What's wrong with the query?
Are these two tables already linked by some common field?? How are the names going to logically match each other? Also as stated, what if you have 2 John Smiths?? What distinguishes the two apart from another? However, if you already have these two related to each other then a simple ComboBox would allow you to automatically pull over the results.