Calculated Percentage showing as 0%0%

[wtucker]

Hello everyone,

I've got a weird one that I can't figure out. I have other forms in which this works perfectly, but I'm getting a strange result in this one.

I have four percentage fields that are manually entered, and a fifth that adds them together. Simple, right? But the fifth field is displaying the others as a string, not a calculated value. It's an unbound field with a control source of

[field1]+[field2]+[field3]+[field4]

The format for each of them is set to a percentage. I've cross-checked it with other forms, and I can't tell what's different. But I tried it with another cell and got the same result, so it must be an issue within my form. Thoughts?

[ssanfu]

It looks like (to me) that field1 and field 2 are text fields and they are being concatenating together.

Are you entering 2% or .02??

Would have to see the dB to be sure......

[wtucker]

It looks like (to me) that field1 and field 2 are text fields and they are being concatenating together.

Are you entering 2% or .02??

Would have to see the dB to be sure......

I had uploaded a new table and forgot to set the field types. Giant facepalm on my part. Thank you!

[ssanfu]

You are very welcome.... glad it was a simple fix.....