I need a query that will combine two tables into one. For example I have a employee table from one db that has all the info I need except for date of birth and Address. I have a table in another db that has this information. I have that table linked I now just need to know how to pull this information into one table/query. The only comon field in both is the name field: LastName, FirstName I
Thanks

Create a query which will output all the fields that you need. Once you have it working right, goto the Query menu and select Make Table Query. Access will then prompt you for the name of the new table, and even give you an option to paste the table in a different database. Yell if you need a hand setting up the original query.

Mike
EchoVue.com

Thank you very much
Dale