Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Number Format (2002)

    Hi,

    I have a query that is used to calculate the average of values per quarter. I've set the number format to general number with 2 decimal places but this does not seem to be applied. I've attached the stripped down version of the database in case someone might be able to suggest what I can do to correct this.

    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Number Format (2002)

    Where specifically is that format failing? You won't see it like that in queries because all that is is the default display format in forms and reports. The entire single is still stored in the field and will show in the queries.
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Number Format (2002)

    Hi Charlotte,

    I've enclosed the report that needs to limit the decimals to 2.

    Thanks,
    Leesha

  4. #4
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format (2002)

    If you define your fields as Fixed instead of General Number it works as you want

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Number Format (2002)

    Thank you! I've never used fixed before and honestly wasn't sure what it was for.

    I appreciate it!

    Leesha

  6. #6
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format (2002)

    Glad to help!

Posting Permissions

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