Updateing info from one table to another

[praclarush]

I'm trying to Update one table with info from another table this is the query that I'm using

UPDATE Formula INNER JOIN TempFormulas
    ON Formula.FormulaID = TempFormulas.FormulaID

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

[NeoPa]

Check out line #4. "TempFormul a" is missing the "s".

Tip: It's much easier to see when the SQL is laid out clearly.

[praclarush]

Thanks, I can't believe i missed something so simple.

Nathan

[NeoPa]

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.