Help-my form is rending the error message Name

[Guest]

I have tried everything I can think of. Can someone please tell me what is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Duane Hookom]

The answer might depend on:
1) what section of the report is this calculation (should be in a Page
section)
2) what is the name of the text box (should not be a field name)

 

[Guest]

It is in the body, not the header of or the footer. It us a text box, (text
380).
I have altered it as follows : =[AL-Complete]+[AL-Daily
Update]+[AL-Appropriate Use] and it no longer yeilds an error message, but it
is not giving me a sum of the values, but rather displaying the values side
by side. For example, the values for each of the above respectively are 2,
4, 4, which should render 10 in the box, however it does not, it displays
244. I am lost

The answer might depend on:
1) what section of the report is this calculation (should be in a Page
section)
2) what is the name of the text box (should not be a field name)

--
Duane Hookom
MS Access MVP
--

I have tried everything I can think of. Can someone please tell me what is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Douglas J. Steele]

Sounds as though they're being recognized as text, not numbers.

Try

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

It is in the body, not the header of or the footer. It us a text box,
(text
380).
I have altered it as follows : =[AL-Complete]+[AL-Daily
Update]+[AL-Appropriate Use] and it no longer yeilds an error message, but
it
is not giving me a sum of the values, but rather displaying the values
side
by side. For example, the values for each of the above respectively are
2,
4, 4, which should render 10 in the box, however it does not, it displays
244. I am lost

The answer might depend on:
1) what section of the report is this calculation (should be in a Page
section)
2) what is the name of the text box (should not be a field name)

--
Duane Hookom
MS Access MVP
--

I have tried everything I can think of. Can someone please tell me what
is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Guest]

THANK YOU!!! You are a life saver

Sounds as though they're being recognized as text, not numbers.

Try

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

It is in the body, not the header of or the footer. It us a text box,
(text
380).
I have altered it as follows : =[AL-Complete]+[AL-Daily
Update]+[AL-Appropriate Use] and it no longer yeilds an error message, but
it
is not giving me a sum of the values, but rather displaying the values
side
by side. For example, the values for each of the above respectively are
2,
4, 4, which should render 10 in the box, however it does not, it displays
244. I am lost

The answer might depend on:
1) what section of the report is this calculation (should be in a Page
section)
2) what is the name of the text box (should not be a field name)

--
Duane Hookom
MS Access MVP
--

I have tried everything I can think of. Can someone please tell me what
is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Guest]

How would I write it if one of the values should change to NA or ""?

 

[Douglas J Steele]

What answer would you want? Do you want to treat NA as 0?

My previous answer to you (before this additional requirement) was

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

If you want any non-numeric input to be treated as 0, try:

=IIf(IsNumeric([AL-Complete]),CLng([AL-Complete]),0) +
IIf(IsNumeric([AL-Daily Update]), CLng([AL-Daily Update]), 0) +
IIf(IsNumeric([AL-Appropriate Use]), CLng([AL-Appropriate Use]), 0)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How would I write it if one of the values should change to NA or ""?

I have tried everything I can think of. Can someone please tell me what is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Guest]

The form uses a series of combo boxes each giving a choice of numeric values,
including 0 and NA; as the answer/input could realistically be 0 or it may
not be an applicaple entry at all. The form then totals all values, so I
need for 0 to = 0 and I need NA to be nothing. 0 is a value, it is important
and NA is no value, so I cannot have NA = 0, as it will screw my final
calculations. Does that make sense?

What answer would you want? Do you want to treat NA as 0?

My previous answer to you (before this additional requirement) was

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

If you want any non-numeric input to be treated as 0, try:

=IIf(IsNumeric([AL-Complete]),CLng([AL-Complete]),0) +
IIf(IsNumeric([AL-Daily Update]), CLng([AL-Daily Update]), 0) +
IIf(IsNumeric([AL-Appropriate Use]), CLng([AL-Appropriate Use]), 0)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How would I write it if one of the values should change to NA or ""?

I have tried everything I can think of. Can someone please tell me what is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Douglas J Steele]

None whatsoever! <g>

You're summing together values. What's the difference between 0 and nothing
when summing?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The form uses a series of combo boxes each giving a choice of numeric values,
including 0 and NA; as the answer/input could realistically be 0 or it may
not be an applicaple entry at all. The form then totals all values, so I
need for 0 to = 0 and I need NA to be nothing. 0 is a value, it is important
and NA is no value, so I cannot have NA = 0, as it will screw my final
calculations. Does that make sense?

What answer would you want? Do you want to treat NA as 0?

My previous answer to you (before this additional requirement) was

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

If you want any non-numeric input to be treated as 0, try:

=IIf(IsNumeric([AL-Complete]),CLng([AL-Complete]),0) +
IIf(IsNumeric([AL-Daily Update]), CLng([AL-Daily Update]), 0) +
IIf(IsNumeric([AL-Appropriate Use]), CLng([AL-Appropriate Use]), 0)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How would I write it if one of the values should change to NA or ""?

:

I have tried everything I can think of. Can someone please tell me

what
is

wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Guest]

I have two sets of sums, one for all points possible and one for points
achieved. Currently I have it set to where if the points achieved box is
marked na, then the points possible box adjusts IE:

pts poss 8,4,10,3 = 25
pts achieved 6,4,0,3 = 13
total score = 13/25= 52%

but if I mark pts achieved like this: 6,4,na,3 = 13 (so you are correct, it
stays the same, however, pts possible changes) pts poss 8,4,0,3 = 15
a total score of 13/15= 87% that is the difference between a fail and a
high pass. I could be overlooking something and any help would be greatly
appreciated.

None whatsoever! <g>

You're summing together values. What's the difference between 0 and nothing
when summing?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The form uses a series of combo boxes each giving a choice of numeric values,
including 0 and NA; as the answer/input could realistically be 0 or it may
not be an applicaple entry at all. The form then totals all values, so I
need for 0 to = 0 and I need NA to be nothing. 0 is a value, it is important
and NA is no value, so I cannot have NA = 0, as it will screw my final
calculations. Does that make sense?

What answer would you want? Do you want to treat NA as 0?

My previous answer to you (before this additional requirement) was

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

If you want any non-numeric input to be treated as 0, try:

=IIf(IsNumeric([AL-Complete]),CLng([AL-Complete]),0) +
IIf(IsNumeric([AL-Daily Update]), CLng([AL-Daily Update]), 0) +
IIf(IsNumeric([AL-Appropriate Use]), CLng([AL-Appropriate Use]), 0)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


How would I write it if one of the values should change to NA or ""?

:

I have tried everything I can think of. Can someone please tell me what
is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you

 

[Guest]

It Works!!! You are right, it works!! I could just hug you, thank you!!!!!

None whatsoever! <g>

You're summing together values. What's the difference between 0 and nothing
when summing?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The form uses a series of combo boxes each giving a choice of numeric values,
including 0 and NA; as the answer/input could realistically be 0 or it may
not be an applicaple entry at all. The form then totals all values, so I
need for 0 to = 0 and I need NA to be nothing. 0 is a value, it is important
and NA is no value, so I cannot have NA = 0, as it will screw my final
calculations. Does that make sense?

What answer would you want? Do you want to treat NA as 0?

My previous answer to you (before this additional requirement) was

=CLng([AL-Complete])+CLng([AL-Daily Update])+CLng([AL-Appropriate Use])

If you want any non-numeric input to be treated as 0, try:

=IIf(IsNumeric([AL-Complete]),CLng([AL-Complete]),0) +
IIf(IsNumeric([AL-Daily Update]), CLng([AL-Daily Update]), 0) +
IIf(IsNumeric([AL-Appropriate Use]), CLng([AL-Appropriate Use]), 0)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


How would I write it if one of the values should change to NA or ""?

:

I have tried everything I can think of. Can someone please tell me what
is
wrong with the following equation?

=Sum([AL-Complete Label]+[AL-Daily Update Label])

Thank you