Finding the sum of the values in a field.

[ia04]

I am trying to create a DB that would calculate the totals of different projects and also calculate the global total (i.e. the total of all the projects combined together)

So far I have created a query that can calculate the total of the projects in a field which I have named Total1. But now I want to calculate the sum of the field Total1, i.e. add all the totals of the projects up.

Sorry my explanation does seem quite lengthy, any help would be much appreciated.

ia.

 

[TedMartin]

Sounds like you need to Create a second query based on the first one and then sum the Total 1 field in the second query

 

[Bodisathva]

assume Query1 contains calculated field projTotal: grandTotal = DSum("projTotal",Query1)

or for display purposes on a form or report group footer use =Sum([projTotal])

 

[ia04]

Thanks a mill guys.
Really helped me a lot!
cheers.

ia.