how to insert data in a table from a select-query???

[marlun]

Hi! I have several select-queries that colloects a value that i want to update a field in a table with. I'm now trying with an update-query, but I get following error-message. "Must use an updatable query!"

I don't know what to do or what is wrong???

thanks
/marlun

 

[LittleSmudge]

Your original Select query was not 'updatable' so you can't expect to convert it to an "Update" query and hope it will work.


If you have a select query that contains :-
a GROUP BY clause
DISTINCT or DISTINCTROW keywords
Or you attempt to change a field at the many end of a relationship in a multi table query without exactly specifying which record in the many table is to be changed

then the Select query is NOT 'updateable' because Access cannot uniquely identify which record is to be updated.


'ope-that-'elps.




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.