#Error 1

[janetlyn]

I'm pretty sure this is a simple and stupid problem but I can't solve it so please help.

I have a form, the form has a box (Text181) with:

=Sum([UseHoursTrips+TtlAllow]

as the formula to get data. This Text181 is in the header. If I just have the UsehoursTrips and take out the TtlAllow and run the problem, the answer is correct. If I reverse it, it is correct again. However, when I put the two together as above, I get #Error. Before I started testing and playing with the Sum I was just getting a wrong numerical answer.

Both fields in the table are numbers.

Suggestions why I am getting this #Error. Thanks, JL

 

[PHV]

Have you tried this ?
=Sum([UseHoursTrips]+[TtlAllow])


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[janetlyn]

Thank you. I knew it had to be simple. The answer is not right, but at least it is not #Error. Thanks a bunch, JL

 

[janetlyn]

PHV. As told above, individually, the answers come up right. But, with the formula as I have it (like the one you showed me), it is only adding up UseHoursTrips which is (50). The TtlAllow is only one number of 42. The answer should be (8). It is showing up as (50). Any ideas please? JL

 

[PHV]

And this ?
=Sum([UseHoursTrips])+Sum([TtlAllow])
What is the type of UseHoursTrips and TtlAllow ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[janetlyn]

I looked at your formula and thought to myself, I have already tried that, but I put it in anyway and I got the correct results. I think I put what you did but added and extra Sum( ) around the whole thing. Thank you so much. You are excellent. JL