By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Updateing info from one table to another

praclarush
P: 27
I'm trying to Update one table with info from another table this is the query that I'm using
Expand|Select|Wrap|Line Numbers
  1. UPDATE Formula INNER JOIN TempFormulas
  2.     ON Formula.FormulaID = TempFormulas.FormulaID
  3.  
  4. SET Formula.Notes = TempFormula.Notes
The problem that I'm having is that its popping up a window for data as if there is a parameter there. this is what I don't understand. I'm coming from a background of t-sql so I'm not entirely familiar with how access works. What I want to do is update a column in the formula table with there corasponding rows in then temp formula table so that if the formula exsists in the formula table then it will move the notes for that formula from the tempformula table to the formula table

that's be best I can think of for explaining it, if you need any more info i would be glad to help

Nathan
Jan 6 '09 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,419
Check out line #4. "TempFormula" is missing the "s".

Tip: It's much easier to see when the SQL is laid out clearly.
Jan 6 '09 #2

praclarush
P: 27
Thanks, I can't believe i missed something so simple.

Nathan
Jan 6 '09 #3

NeoPa
Expert Mod 15k+
P: 31,419
No worries. It's much harder to see when the SQL is laid out simply as it comes. I always reformat my SQL when I'm working on it.
Jan 6 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.