Updating a Table from a second Query.

[israellawndale]

HI Everyone,

Please help understand something that most people know. Let me explain.

Let's say I have a table with employee's info In that table there's a field about their salary. In this table I have different pay scales. I have another table with Just pay scales..for instance

employetbl
Auto Record EmployeeName Workaddress PayGrade Salary
1 Joe "B"
2 John "C"
3 Steve "A"

salarytbl
Auto Record Grade Salary Comments
1 "A" $25.00 Technician


2 "B" $22.00 Administrative
3 "C" $23.00 Operations Spec.


If I were to run a a query from the employee table and pull all the fields to my QBE under design view. and selected my criteria and UpdatedQuery to change the update to...(what do i click to get to change the new salary.. ???.


A) Select the proper criteria and and change the update query to the new
salary and do it manually?....
B) Can I somehow follow option "A" but at the end select the proper "grade" under my update query and let that somehow change
it to the new salary?...(with out me having to type the salary..but only
the salary grade?)
C. Or can I just type the auto record under to the updated query . Under my update query to ??.

in other words I am trying to select a salary from me typing a record number or a salary grade field..


thanks

[alansidman]

Here is a tutorial on Update Queries.

http://www.bluemoosetech.com/microso...Update%20Query

Alan

[israellawndale]

thanks!!.. The video actually stops right before It talks about updating a query.. Do you have the second part... This video stops at three quarters of the video.

[alansidman]

Been awhile since I watched that video.

Here is another video that does a lot of data manipulation through updates. It should be more helpful in understanding the process.

http://www.datapigtechnologies.com/f...anipulate.html

Will also show you how you can do some data manipulations in queries.

Alan

[israellawndale]

Dear alanssidman , .. thank You!! the video was great!... I can continue now with other stuff!..


Have a good day!!!