Query Results- Incorrect formatting

[Guest]

Hi,

I have a query that is summing up column A which is formatted as
Number-Double in it's current table. The results of the query should show up
as 0, but they are showing up in scientific format- All of the other records
are showing up correctly in this same query. I even tried the following
Val(format([tablename].[fieldname],"#.00")) and this gave me the same results.
Any help would be appreciated.

Thank you.

 

[John Spencer (MVP)]

How about
CCur([tablename].[fieldname])

That should truncate the number down to four decimal places, which would drop
any small residual.

Watch out for nulls though.

 

[Van T. Dinh]

Try setting the Format of the Query Column / Field to "#.00". In the
DesignView of the Query, select the required Field and open the Properties
window. There should be a "Format" row in the Properties window for you to
enter the format.