Hi I am fairly new to Access.

I am trying to create a field (Field B) that is based on the total of another field (Field A) within the same query. I have managed to do this using the DSum function.



DSum("[EU Imports.2006]","[EU Import Tariff weights]") AS [2006 Total Trade]

My new issue is that I would like to have the "total" of Field A change if I filter the query result in the datasheet view. Is this possible?

For Access 2007 I am able to have totals at the bottom of each query added through the navigation pane, can I use this in calculating a field for the query itself?

Thanks
Yash