Simple query issue - reqordset not updatable

[mattsteele8]

hi,

i have a query which i have simplified for the purposes of fault finding which brings the error "the recordset is not updatable" whenever i try to change an item in the issues column. the sql query is below

SELECT tblSupportCalls.IDSupportCalls, Count(tblSupportCallsChild.IDSupportCallsChild) AS CountOfIDSupportCallsChild, tblSupportCalls.Issue
FROM tblSupportCalls INNER JOIN tblSupportCallsChild ON tblSupportCalls.IDSupportCalls = tblSupportCallsChild.IDSupportCalls
GROUP BY tblSupportCalls.IDSupportCalls, tblSupportCalls.Issue
ORDER BY tblSupportCalls.IDSupportCalls DESC;

i have googled for a bit but non of the suggestions apply or fixed it e.g. make sure the query is set to Dynaset and make sure there are no left joins

any help would be much appreciated

 

[GUIDO22]

You will not be able to update a recordset that is composed from two seperate tables, like you have shown since you are using the Group by clause.

 

[pbaldy]

First item:

http://allenbrowne.com/ser-61.html

 

[mattsteele8]

thanks for your replies

any one have a fix for the query or a work around that means that i will not have to use the group by clause. I have been asked to use the dsum so i will try and write an expression that incorporates that