DSUM in a SQL Statement

[incagold]

Hi,

I am a relative newbie to MS ACESSS and I am having a terrible time trying to use DSUM in a SQL Statement to update a table. No matter what I do my answer gives me 0's for result. I am sure it is my newness and the answer is probably quite simple. But I am struggling.

This is the code:

UPDATE SUMMARY SET SN4_BE = DSum('BOE','SUMMARY_TMP','SER_NO'='SN4'), SN4_PO = DSum('O_CST','SUMMARY_TMP','SER_NO'='SN4'), SN4_RC = DSum('A_CST','SUMMARY_TMP','SER_NO'='SN4'), SN4_PF = DSum('PJ_FNL_CST','SUMMARY_TMP','SER_NO'='SN4');

SUMMARY is the final table and SUMMARY_TMP holds the data which needs to be evaluated.

Any suggestions and help would be sincerely appreciated.

BEF

 

[JohnDTampaBay]

This is a SQL Server forum. Try posting the the Access forum. Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[incagold]

Sorry. Like I said I'm relatively new and finding my way around. Thanks for pointing me in the right direction

BEF