#Error in calculated field

[Guest]

I'm trying to put a calculated field in a report but I get a #Error message.
If I display the fields I get a blank and a value. The 'Vacation Days Used'
field is blank (or Null or something). The VacationSum field has a value in
it. Is this caused from trying to add a Null with a numeric value? And if
so, how to I get around it?

 

[Guest]

If I display the fields I get a blank and a value. The 'Vacation Days
Used' field is blank (or Null or something).
Your statements are contradictory -- Blank has no value - Something is not
blank.
Post your calculation.

 

[Guest]

What is the formula you are using for this field?

Steve

 

[Guest]

I'm adding 2 fields: =[vacation used]+[vacationsum]

[vacation used] was defined as a text field on the record I'm taking it
from. How do I get it usable in an equation? The other field [vacationsum]
works fine. It was created as a numeric field. I've tried redefining the
record fields but it's not helping.

 

[Linq Adams via AccessMonster.com]

What would sample data look like in the [vacation used] field? You're not
trying top get your target textbox to look like

Vacation Days Used 6

or some such, are you?

 

[Mike Mueller]

You cannot add a string to a number. You would need to use the VAL function
on the string to convert to a number
eg vacRemaining = val([vacEarned]) - vacUsed

I'm adding 2 fields: =[vacation used]+[vacationsum]

[vacation used] was defined as a text field on the record I'm taking it
from. How do I get it usable in an equation? The other field
[vacationsum]
works fine. It was created as a numeric field. I've tried redefining the
record fields but it's not helping.

What is the formula you are using for this field?

Steve

 

[Guest]

Thanks! I figured that was the problem but didn't know how to work around it.

You cannot add a string to a number. You would need to use the VAL function
on the string to convert to a number
eg vacRemaining = val([vacEarned]) - vacUsed

I'm adding 2 fields: =[vacation used]+[vacationsum]

[vacation used] was defined as a text field on the record I'm taking it
from. How do I get it usable in an equation? The other field
[vacationsum]
works fine. It was created as a numeric field. I've tried redefining the
record fields but it's not helping.

What is the formula you are using for this field?

Steve

:

I'm trying to put a calculated field in a report but I get a #Error
message.
If I display the fields I get a blank and a value. The 'Vacation Days
Used'
field is blank (or Null or something). The VacationSum field has a
value in
it. Is this caused from trying to add a Null with a numeric value?
And if
so, how to I get around it?