How to sum data of a column and write the result in a new field in the database

I want to summarize all data of a specific column and the result to be written to a new field (or to a new table) of the database... (Access Database)

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece

You should be able to use standard SQL for this, something along the lines of :


UPDATE yourtable SET columnname =
(SELECT SUM(columntosum) FROM othertable) WHERE
columnid = column_id_you_are_looking_for


Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb