Forms summing

[Dave]

I have a popup form with 5 text Boxes
RedCount
WhiteCount
YellowCount
PurpleCount

txtTotal

I want to sum the first 4 boxes in the 5th
Why is this not working?
=[RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount]
Or
=sum([RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount])
In the control source of txtTotal

All 5 boxes are formatted to be general number and first 4 have a default
value of 0
All I get is either "error" or "name" depending on what I try to put as my
code

Am I missing something?
Any help here will be appreciated

Thanks in advance

D

 

[Guest]

Odd because it works for me.

Having said that, you would need a very good reason to store the calculation
directly in the table. It is better to do it in a query.

 

[Dave]

None of these numbers are being stored.
they are 5 ubound text boxes.
D

Odd because it works for me.

Having said that, you would need a very good reason to store the
calculation
directly in the table. It is better to do it in a query.

--
www.ae911truth.org

I have a popup form with 5 text Boxes
RedCount
WhiteCount
YellowCount
PurpleCount

txtTotal

I want to sum the first 4 boxes in the 5th
Why is this not working?
=[RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount]
Or
=sum([RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount])
In the control source of txtTotal

All 5 boxes are formatted to be general number and first 4 have a default
value of 0
All I get is either "error" or "name" depending on what I try to put as
my
code

Am I missing something?
Any help here will be appreciated

Thanks in advance

D

 

[Guest]

You didn't say they were all unbound!

What do you want to do?

None of these numbers are being stored.
they are 5 ubound text boxes.
D

Odd because it works for me.

Having said that, you would need a very good reason to store the
calculation
directly in the table. It is better to do it in a query.

--
www.ae911truth.org

I have a popup form with 5 text Boxes
RedCount
WhiteCount
YellowCount
PurpleCount

txtTotal

I want to sum the first 4 boxes in the 5th
Why is this not working?
=[RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount]
Or
=sum([RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount])
In the control source of txtTotal

All 5 boxes are formatted to be general number and first 4 have a default
value of 0
All I get is either "error" or "name" depending on what I try to put as
my
code

Am I missing something?
Any help here will be appreciated

Thanks in advance

D

 

[Dave]

Sorry - you are correct (I did not mention that) and aftrer sleeping on it
for the night I think I came to understand that if they are unbound I can't
total them.
back to the drawing board.

Thanks for the replies
D

You didn't say they were all unbound!

What do you want to do?

None of these numbers are being stored.
they are 5 ubound text boxes.
D

Odd because it works for me.

Having said that, you would need a very good reason to store the
calculation
directly in the table. It is better to do it in a query.

--
www.ae911truth.org



:

I have a popup form with 5 text Boxes
RedCount
WhiteCount
YellowCount
PurpleCount

txtTotal

I want to sum the first 4 boxes in the 5th
Why is this not working?
=[RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount]
Or
=sum([RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount])
In the control source of txtTotal

All 5 boxes are formatted to be general number and first 4 have a
default
value of 0
All I get is either "error" or "name" depending on what I try to put
as
my
code

Am I missing something?
Any help here will be appreciated

Thanks in advance

D

 

[Guest]

What do you want to do?

--
www.ae911truth.org

Sorry - you are correct (I did not mention that) and aftrer sleeping on it
for the night I think I came to understand that if they are unbound I can't
total them.
back to the drawing board.

Thanks for the replies
D

You didn't say they were all unbound!

What do you want to do?

None of these numbers are being stored.
they are 5 ubound text boxes.
D

Odd because it works for me.

Having said that, you would need a very good reason to store the
calculation
directly in the table. It is better to do it in a query.

--
www.ae911truth.org



:

I have a popup form with 5 text Boxes
RedCount
WhiteCount
YellowCount
PurpleCount

txtTotal

I want to sum the first 4 boxes in the 5th
Why is this not working?
=[RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount]
Or
=sum([RedCount]+[YellowCount]+[WhiteCount]+[PurpleCount])
In the control source of txtTotal

All 5 boxes are formatted to be general number and first 4 have a
default
value of 0
All I get is either "error" or "name" depending on what I try to put
as
my
code

Am I missing something?
Any help here will be appreciated

Thanks in advance

D