Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicka
Starting Member
28 Posts |
 Posted - 2002-10-01 : 11:35:11
|
| I have a table called tbl_Main with a field text field "Calc" and a field called "NewCalc"."calc" reads (is connected) from a table called "tbl_Calculator" the field called "CalcDescription".I need to create a query that reads the field "Calc" and identify the ID from the tbl_Calculator and insert that ID into the "NewCalc" field.HelpThanks |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-01 : 13:22:26
|
| You could do that using an update query.....UPDATE tbl_Main INNER JOIN tbl_Calculator ON tbl_Main.calc = tbl_calculator.calcdescription SET tbl_Main.NewCalc = [tbl_calculator].[ID];===========Paul |
 |
|
|
nicka
Starting Member
28 Posts |
Posted - 2002-10-01 : 13:33:42
|
Thanks Paul it worked.Nickquote:
You could do that using an update query.....UPDATE tbl_Main INNER JOIN tbl_Calculator ON tbl_Main.calc = tbl_calculator.calcdescription SET tbl_Main.NewCalc = [tbl_calculator].[ID];===========Paul
|
|
|
|
|
|
|
Mapping one field into another in Access