Edited in from original main question ( @Ratslinger ):
I have set up a simple data base with one input Form, one main Table, and a Query. In the Query there is a calculated field. The problem is that the result of the calculation is wrong.
End edit.
The digits are correct but the decimal point is in the wrong place, so the result is 100 x greater than it ought to be.
The database is for a tree plantation where the trees are planted in blocks of known area (hectares). I use the word “block” and not “field”, to avoid confusion with “Field” as in a database. The three Fields are: Block Name, Block Area, and number of Trees in Block.
In the Query I want to divide the number of Trees by the Block Area to get the number of trees per hectare (Stand per Hectare, or SPH).
For example: Block Area 25.00, number of Trees 4,000, result should be 160, but it shows as 1,600.
What am I doing wrong?