On Fri, 31 Oct 2003 08:46:55 -0800,
Ok. You're not updating any fields to anything. Normally after the SET
keyword you would indicate what fields you want updated, and what you
want them updated to: for instance
SET [Contacts1].[LastName] = [Employers1].[LastName]
That's why you're getting the error message - you're creating an
update query and then not updating anything!
In the query grid, select all of the fields in Contacts1 that you want
to update; on the Update To line of the query grid, type in
for the field containing the data you want to insert.
Note that the LEFT JOIN is going to cause problems. If there are
records in Contacts1 which do not exist in Employers1, you will get
NULL values for all the fields in Employers1 for those records; the
update query will then erase any existing data. Is that what you want,
or do you want to change it to INNER instead of LEFT?
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday