update query

[dcarbone]

How do i create an update query in access that will prompt the user to enter in values that need to be entered into 7 fields in a table

 

[scriverb]

Use the following SQL for your update query with modifications of the table, field and prompts. Just use this as a format for what you need:

UPDATE tblYourTableName as A SET A.Field1 = [Enter what you want to update in Field1:], A.Field2 = [Enter what you want to update in Field2:], A.Field3 = [Enter what you want to update in Field3:], A.Field4 = [Enter what you want to update in Field4:], A.Field5 = [Enter what you want to update in Field5:], A.Field6 = [Enter what you want to update in Field6:], A.Field7 = [Enter what you want to update in Field7:];

Let me know if this is what you wanted.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???