UPDATE and INSERT count value

[dharkangel]

Hi,

I have this query I am trying to do, but I'm getting an 'operation must be an updatable query'. Can anyone tell what is wrong with my query?

UPDATE Table1 SET EUM = ( SELECT COUNT(Table2.Role) FROM Table2 WHERE Role='EUM')
WHERE Table1.ID=1;

 

[PHV]

'operation must be an updatable query'
Seems like an Access issue:
UPDATE Table1
SET EUM = DCount("Role", "Table2", "Role='EUM'")
WHERE Table1.ID=1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dharkangel]

thank you again, this worked great