Displaying as a percentage

[AHT Barry]

In my SQL Query I am selecting two fields from an Access database, both of
which are numbers. I am then dividing the two together and using AS to create a
new virtual field. The new "Percentages" field is showing the correct answer
but the answer is in decimals (i.e. .666666) and I need it to be formateed as a
percentage (i.e. 67%). Is there a way to do this in ColdFusion? Part of my
SELECT statement is below;

Evaluations.Total_Points/QuestionSet1.A_Answer_Points AS Percentages (i.e.
4/6+.666666666)

Is there a way to refernce the variable #Percentages# and have it displayed as
a percentage?

Thanks for your help

[MikerRoo]

Yes, you can do calculations and formatting on #Percentages#.
Something like "#Round (Percentages * 100.0)#%" would work. BUT...

You may be able to do this much more elegantly in Access.

Try changing that select snippit to:
SELECT Format (Evaluations.Total_Points/QuestionSet1.A_Answer_Points, "0%") AS
Percentages

Regards,
-- MikeR

[Mr Black]

Minor correction to the last post.

Round() will work perfectly, if you are interested in whole percents. If you
may (or want) to have something like: 3.5%, the NumberFormat() is more
appropriate. NumberFormat() also does requested rounding for you. For example:

NumberFormat(num*100, "___._") - percent with one decimal.

[MikerRoo]

Mr Black's right if you want to futz around with formatting after the fact.
NumberFormat() is better than Round() from a code flexibility standpoint.

However, NumberFormat() isn't half as powerful as Access' Format() function.
(Format() formats %, for example, NumberFormat() doesn't).

My point was it is better to format the data the way you want it at the
beginning (the database), than to clean it up later.
Cleaning it up later, costs more code and more processing time.

-- MikeR

[AHT Barry]

Thanks for the help guys. I tried to use the suggestion for formatting it in
Access but kept getting a "missing parameter" error. I did howver get it to
work using the NumberFormat() tag in ColdFusion and it is worknig perfectly!

Thanks again.

[MikerRoo]

You got that missing parameter error because of the way CF handles quotes for Access. My bad.
Change "0%" to '0%' (single quotes) and it will work.

-- MikeR