Re: Format

HI Allison

On Mon, 1 Apr 2002 17:42:37 -0500, "Allison Callahan" <acall2464_at_hotmail.com> wrote:

>If A = 1, B = 3
>
>SELECT ((A/B)*100) AS Pct ....
>
>How do format Pct so that the calculated field will be displayed as 33%
>instead of 33.333333?

SELECT round (((A/B)*100),0) AS Pct ....

Franz-Josef Received on Mon Apr 01 2002 - 16:29:29 CST