Number Formatting

[renenger]

I am trying to calculate the square footage on a form. The formula I have is

(WxH)/144


For example:

W = 6.375
H = 11.5

Square footage should be 0.509115

However I am getting 632.500000


The width (W) and height (H) are formatted as double. So is the square footage. Is this not correct?

 

[pbaldy]

Worked in a brief test for me. Can you provide more info about how you're doing this, or a sample db?

 

[renenger]

Number Formatting Sample

Here is a sample DB with the problem that I am encountering

 

[pbaldy]

For some reason I don't have time to look for, every record sees the width as 7920. I renamed the width textbox to txtWidth and all is well (after correcting the calc field, which was only w*h).

 

[renenger]

Thank you so much. I changed the calc field to determine when it was breaking. I couldn't figure out why the width * height was not multiplying correctly.

I really appreciate your help!!!