"operation must use an updatable query"

[MelissaBerrett]

I have a table named Code and a query TermEmployee. The query produces a calculated field called CountofStatus. I'm trying to get the data from CountofStatus to update the Term field in my Code Table. I wrote this in SQL:

UPDATE Code INNER JOIN TermEmployee ON Code.Term = TermEmployee.CountofStatus SET Code.Term = TermEmployee.CountofStatus;

I get the error msg "operation must use an updatable query", What could be the problem? Thanks for any help.

Mel

 

[Darrylles]

Hiya,

You can't update from a query that includes a calculated field.

You can't even update from a query that uses ANOTHER query that includes a calculated field.

Do a search in Access for 'query' and 'calculated'.

I've got a major prob. because of this.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[hughclaire]

Run a make-table query from TermQuery. Use the table and Code table in the update query. It should work.

 

[MelissaBerrett]

Thanks for the reponse, creating a table was exactly what I needed to do. Now, I can run the query, but my records aren't updating. Any Hints?
Mel