Parameter Query of Two Tables

[mikeiswayawesome]

I am trying to query two tables in MS Access at once and display the results in a single sheet. I can do this fine separately but am clueless when it comes to putting it together. I want to do this using a parametric query. The data in these two tables is pretty much the same except some formatting varies. I am searching them by an index number which varies in format so I am using the "LIKE" code. One table has separate fields for first and last name while the other combines the name into one field. In the results I could probably have fields for first and last but simply put the combined name field in the last colmn. Please help!

 

[Tiro Cupidus]

Try search Access help for "Union Query" to see if that's what you're looking for.