Re: Format output as %

Thanks for the fast response!

My query, unfortunately, is a SQL only query. As a result, I can't use
the design window. Is there a way to do this in SQL?

KARL DEWEY wrote:
Open the query in design view, click on menu VIEW - Properties, click on you
output field, in the Format line type PERCENT. Remove the *100 from your
calculation.

"Scott" wrote:

Can you tell me if there is a way to cause a query to output a field in
percent format?

I have a query that calculates a range of summary values. Some of these
results are percents, which I currently calculate as
(B/A)*100=Percentage.

The results of this show a value like 28.20545. I would like them to
show as something like 28.2%.

Can you suggest a way to make this happen?

Thanks!

Scott



.

Relevant Pages

  • RE: current month / year WHERE
    ... I am making the assumption that qryCompsFacsPerMonthSum100M is a query ... "KARL DEWEY" wrote: ... format. ... This returns the correct data however the bar graph displays the months ...
    (microsoft.public.access.queries)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: mySQL Problem
    ... And when the query gets executed i get back the following error: ... Actually, problem is proper quoting, not the format or anything else. ... the SQL standard and won't work on any other RDBMS I'm familiar with. ... you admit that mssql uses something DIFFERENT and PARTICULAR to alias? ...
    (comp.lang.php)
  • Re: VBA ADO SQL Query Problem
    ... For long queries on a Oracle DB, I often meke it easy by using Business ... Object where I copy the SQL statement from. ... query parameter in the Oracle date format. ... But the query DID work, only no records were retrieved ...
    (microsoft.public.excel.programming)
  • Re: Format issue ... 2 decimal places displayed?
    ... Jeanette Cunningham wrote: ... to get sql of your query, open the query in design view, then select Query | SQL view from the menu. ... you applied the format to the combo box. ...
    (microsoft.public.access.forms)