Calculating from a Table

[Swarland]

I have a table (table2) that has fields to hold another tables ID (table1) and a currency total.



From a form that relates to the table1 ID, I want to click a button that then totals all of the currency fields from table2 that have the same ID as in table1. The total then is to be inserted into a grand total field in table1.

I have a query that does this, but don't know how to run this in vba and to extract the grand total figure from the query result.

I have also tried to run a for, next routine, but get into difficulties in addrssing the table.

Can anyone help please?

regards

Swarland

[RuralGuy]

How about using a DSum() function?

[Swarland]

Many thanks RuralGuy, it works a treat. Hope it isn't too cold at 8300'.

Regards

Roger

[RuralGuy]

Many thanks RuralGuy, it works a treat. Hope it isn't too cold at 8300'.

Regards

Roger

Temp is just fine for me. Glad I was able to help.