Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    19

    Unanswered: number with 2 decimal places always

    Hello, I want to my numbers have always 2 decimal place, i.e:
    If I have the number 134 , I want to the query return 134.00
    How can I do it?

    I have proved ROUND in my select , but it hasn't worked with number hasn´t any decimal.

    can anybody help me? Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168
    Format([FieldName],"#,##0.00")
    J.

Posting Permissions

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