Jim-
Yes, it sounds crazy. What is the purpose of the table, what are the relevant
columns, and why do you need to update the employee ID? If all will be set to
the same value, then you can do it in one query.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Nashua, NH)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Monday, March 05, 2012 10:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Update query for 5 fields
Hello all
I have a table that has employee Id's in it. The way the table is set up might
sound crazy but it is the way it needs to be. But in each of the columns there
is an employee ID that I need to update to a new ID. Is there a way to update
all 4 columns at the same time without writing 4 update queries?
Thank You
Jim Wagner
The fields are
AstSup/Lead
Supervisor
Asc/Ast Dir
Dept Head
Person ID
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar