Scientific Notation in Report

[antinora]

Greetings:

I have a calculated field in a query: PENeeded: IIf(5-[PE]>0,5-[PE],0) which pulls PE field from this field: PE: Nz([Health/Physical Education earned],0)

It works beautifully unless the None-Zero calculation is greater than zero but less than 1. The query and therefore the report displays the value in scientific notation. ex. 5.9999999999e+02 instead of 0.59.

Is there a default I may set so as to remove scientific notation? On the report the number is displayed as ############## since the field is too small to display the large scientific notation value.

Thanks in advance.

John A
NY USA

 

[Joe4]

Try formatting the field to only display two decimal fields.
Or try using the ROUND function to round the results to two decimal places.

 

[antinora]

Thanks brother!