how to calculate textboxes in a report?

[behedwin]

I have a report with 7 textboxes that are populated from a query.

I have created a 8th textbox where i want to sum up the textboxes.

the first 7 textboxes are short text in the table.
the 8th textbox i want to write a formula so it takes the current value of the 7 textboxes and show me a total value
textbox 1 + textbox 2 + textbox 3 + textbox 4...........


how do i do this?
it does not work to just type in the data field
=[textbox1]+[textbox2].....
i get no errors and no result

 

[sheetspread]

Are they numbers to be added or text to be joined? Is there grouping in the report and you're crossing levels to sum the textboxes? Can you calculate the sum in a query and add that to the report instead?

 

[behedwin]

I tried to solve this with VBA
but i get null errors now

i also changed the table objects from short text to number.

Dim tot1 As Double
Dim tot2 As Double
Dim tot3 As Double
Dim tot4 As Double
Dim tot5 As Double
Dim tot6 As Double
Dim tot7 As Double
Dim total As Double

tot1 = Report_Lonfordel.t1.Value
tot2 = Report_Lonfordel.t2.Value
tot3 = Report_Lonfordel.t3.Value
tot4 = Report_Lonfordel.t4.Value
tot5 = Report_Lonfordel.t5.Value
tot6 = Report_Lonfordel.t6.Value
tot7 = Report_Lonfordel.t7.Value

total = tot1 + tot2 + tot3 + tot4 + tot5 + tot6tot7

      Report_Lonfordel.txttotal.Value = total

but this code gives me error on null value

 

[sheetspread]

Why aren't they formatted as number?

 

[behedwin]

i changed it to be numbers.

but still not getting the correct answer...

i noticed if i got any of the texboxes empty (sometimes they are). Then i get no result when calculating.
i need the calculation to work even if some of the textboxes are empty.

 

[sheetspread]

set the default value to zero then

 

[behedwin]

how do i do that?

 

[behedwin]

Dont get it...
googled around on how to set the default value on a textbox, but it seems i cant?!

and if i look in my table the default value of the record is already set to 0

but when i calculate the textboxes i get no answer if one of them is empty.

 

[welshgasman]

Why not just do the math in the query?

 

[behedwin]

That worked.... but when a user deletes the 0 from any textbox... and just leaves it empty.
The calculations stops to work.

So can i setup so that there must be a value atleast or make the calculation work even if one of the textboxes are empty.

default value works. but if a user takes away the 0
then it is not put back in by default value....