Calculated field (control) on (sub)Form

[likecricketilovesit]

Hi there, I'm hoping you wonderful people can help me?!

I've tinkered with this very simple calculated control (Volumetric) on a form but for the life of me cannot get it to calculate correctly.

=([Length]*[Width]*[Height])/5000
Based on this (36*27*14)/5000 it should be 2.7216 but its 1029.07?

I'm sure it's a very simple and basic error from me but welcome your help as ever, thanks Simon

 

[MajP]

Try making a calculated column in the query instead. Curious if you get something different. Validate all the fields datatype are numeric and not short text.

 

[likecricketilovesit]

Thanks Majp. I renamed all the table fields which seemed to fix it

 

[Pat Hartman]

I renamed all the table fields which seemed to fix i

If they contained parentheses, that's good Column and object names should not include special characters or embedded spaces. Leave those things for labels.