hi all, i'm really new to this stuff.i have created 4 tables, which are-Daily-DailyAccount-Record-Transit's a simple database design, where table Daily keeps the cash in, cash out. DailyAccount keeps the calculated cash in, cash out (from table Record). Record keeps all the transaction made within each day and Trans keeps the transaction ID and it's details.the following SQL query was created in MSACCESS database,UPDATE DailyAccount SET DailyAccount.SoldWeight = (SELECT SUM(Record.Weight) FROM Record, Trans WHERE ((Record.TransID)=(Trans.TransID)) AND ((Trans.TransSum)=True))WHERE ((DailyAccount.Date)=dd); (note that 'dd' is the user input date to update the data)when the query is executed, MSACCESS returns this errorOperation must use an updateable query...have no idea what's wrong with it. i tried changing the SELECT command to number like 999 and the query works fine.appreciate all the help