troubleshooting Question

Update SQL in MS Access

Avatar of ellenjbr
ellenjbr asked on
SQL
15 Comments2 Solutions293 ViewsLast Modified:
Using MS Access 2002 SQL ...

I want to update the values of a field in table one, a text field with numeric values to their respective text equivilent located in another table (two) which consists of 2 fields, the text equivilent and its numberic id number.  Each time I attempt using an update SQL, I get one error or another.  The following is an example as I need to do many of these.

UPDATE [Future Homes] INNER JOIN playuda
ON [Future Homes].FUTURE_HOME_ID = playuda.FFHome
SET playuda.FFHome = [future  homes].[future_home_name]
WHERE (((playuda.FFHome)=[future homes].[future_home_id]));

FYI:
playuda.ffhome is a numeric value (text field)
future homes.future_home_id is a numeric value (text field)
future homes.future_home_name is a text value (text field)

Thank you.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 15 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros