ty for the reply but i get this error Syntax error (missing operator) in query expression 'SUM(Accessory_Table.Qty * Accessory_Table.Cost) FROM Stock_Table INNER JOIN Accessory_Table ON Stock_Table.StkCode = Accessory_Table.StkCode'. this is my actual code "UPDATE Stock_Table " & _ "SET StkCost = SUM(Accessory_Table.Qty * Accessory_Table.Cost) " & _ "FROM Stock_Table " & _ "INNER JOIN Accessory_Table " & _ "ON Stock_Table.StkCode = Accessory_Table.StkCode" maybe UPDATE and SUM doesnt really work together in access?

is this possible in visual basic.net? cant seem to make it work vb.net using access database oledb update t1 set t1.f1 = (select sum(t2.f1) from t2 where t1.code=t2.code) ty in adv

sorry yup im using access

ty for the prompt help but could i ask for code sample? insert into C:\database2... select * from c:\database1... ty

looking for an alternative and efficient way to transfer table records from one database to another database. could it be done with one sql? ty in advance maytel

done cleaning usercontrol solution and the new application soultion it still doesnt debug they way it was before. this works if myfunction() then but this doesnt if usercontrol.reccount = 0 then already set debug build in configuration manager of new application but still no success

i cant debug my usercontrol i have applied in another solution settings problem maybe? because i was able to debug before. if grid.reccount = 0 then before it would go into the function reccount but now it just doesnt please help tnx in advance

ty for the jumpstart

hello i have two computer both are connected to the internet i would like to create a client program that could download a file from a server where do i start? ty in advance.