I have the following query and when I try to execute it I get a message of You have written a subquery that can return more than one field without using the EXISTS reserved work in the main querys from clause. I'm using Microsoft Access and am not sure how to revise the query. Any help would be greatly appreciated. I'm using Microsoft Access 2003.
update caserecords b
set unithours = (select caseid, sum(casehours) as hours, int(sum(casehours)/60)&":"& (sum(casehours) mod 60) as total_time from contactevents a
where b.id = a.caseid
group by caseid)