Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    16

    Unanswered: formatting decimal places in a query

    Hey - I have a quick question and know that it is probably pretty simple, but I am stumped. I have a query where I need to make a colum a number that looks like a percent with 2 significant digits:

    i.e.,
    SELECT tblNumericCovert.number1, tblNumericCovert.number2, [number1]/[number2] AS testDiv
    FROM tblNumericCovert

    where testDiv needs to spit out results like this ###.##

    I am totally lost, if anyone can help, I would appreciate it.

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    check out:

    FORMAT(number1/number2, 2)

    This will print number with 2 decimal places.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •