Summing values

[jamesker]

Hi,

I have a continuous form that has Project name as the first column and
then a bunch of values for each project as the rest of the colums, ie:


Project Name | Num of wells | Wells Surveyed | Wells Aquired.......
Chigwell | 8 | 9 |
15 ..........
Beiseker | 9 | 18 |
24 .........


the list continues and has about 15 colums and 50 rows or "Project
Names". I want to have a sum of all the numbers in the columns for
all the projects at the bottom. like this:


Project Name | Num of wells | Wells Surveyed | Wells Aquired.......
Chigwell | 8 | 9 |
15 ..........
Beiseker | 9 | 18 |
24 .........
____________|____________|______________|______________________
Total: | 17 | 27 |
39 .......

Currently I have made a bunch of text boxes in the footer of the form
and in each on i make the control source: =sum( [Num of wells] ),
etc. it works fine for about the first two colums but when i add in
all the "total" text boxes for all the columns, i get a reading of
#Error. It seems that access in unable to compute that many sums,
which is silly. If anyone has a solution to my problem, i could
really use it. Thanks

 

[jamesker]

Those examples didn't turn out as i'd hoped, they're supposed to look
like this:


Project Name | Num of wells | Wells Surveyed | .......
Chigwell         |        8           |          9            |
 .......
Beiseker        |        9           |          18         | ......



Project Name | Num of wells | Wells Surveyed | .....
Chigwell         |        8           |          9            | .....
Beiseker        |        9           |          18           | .....
____________|____________|______________| .....
Total:             |       17          |          27           | .....

 

[Dominic Vella]

If, for example, your fields were [project_name], [project_number] and
[project_surveyed], then you would add text boxes into the FOOTER of the
form, one with the control source being:
=Sum([project_number])
the other being:
=Sum([project_surveyed])

I hope that helps


Dominic Vella

 

[jamesker]

yes that's what i have done, and that works for say 5 columns, but as
soon as i make text boxes for all 15 columns, everything messes up and
i get the #Error in all of the text boxes.

 

[jamesker]

nevermind, the problem was that i had null values in some of the
columns that were messing up the sum function. I changed all the null
values to 0's and everything now works fine. thanks