Query Results- Incorrect formatting


G

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.
 
Ad

Advertisements

J

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.
 
Ad

Advertisements

V

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top