FormatNumber

May 2, 2005

I am trying to use a query I made with a newer version of Access on an older one. The older one does not recognize the 'FormatNumber' function and I believe this has to do with the fact that it uses the Microsoft 9.0 Object Library. Is there an equivalent to the FormatNumber function in 9.0?

Thanks
Beatrix

View Replies


ADVERTISEMENT

Formatnumber To Format A Sum Field In Query?

Feb 29, 2008

I have a query that calculates a sum like this:

Sum: [table1]![field1]*[table1]![field2]

I would like result to have 2 decimal places.

I tried to use formatnumber like this:

Formatnumber(Sum: [table1]![field1]*[table1]![field2];2)

But I get syntax error. please help with the correct formula.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved