[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___