Percent Format In Query Grid Of Make Table Query

[The Brown Growler]

Hi,

Could anyone please asssist with the syntax to format a field value as percent to two decimal places in a make table query ?

I have the field format set to percent via the properties and the query displays percentages. However when I run it to make the table it creates the table with numeric values.

I know there is some means to do this using the Format function in the query grid but my various attempts have failed.

Thx

 

[jal]

Have you tried the round function? E.G.

SELECT Round(50.23423,2)

returns a value of 50.23 (2 digits past the decimal point).

But i'm not sure if rounding up or rounding down might upset any of your values.

 

[jal]

Just realized the other problem - in cases where there is no need for 2 decimial places, you'll get no decimal point at all,

e.g. Round(55, 2)

returns 55 instead of 55.00

 

[jal]

I noticed that

FormatNumber(55, 2)

Does return 55.00

 

[jal]

I just tried the FORMATPERCENT FUNCTION
Works same as FormatNumber except
(1) Multiples the number by 100
(2) Adds a percent sign at the end