Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    10

    Red face Unanswered: Format data problem....properties blank?

    Query form creates data with too many decimal places and when selecting properties (under query design) all fields are blank? No predifined drop down formats exist?
    ..ok let me try again...my query calculations create data with what appears to be the default 13 decimal places...I'd like to trucate to one or two but when I select "properties" both the General and Lookup tabs are blank and have no drop downs to format data under the general tab.
    Last edited by cormier35; 04-16-09 at 18:27.

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums

    I have to say, I'm not sure I quite understand your problem; don't forget to check out Teddy's FAQ (the "Read Me First - NO SERIOUSLY" post on the main page). If I have to take a stab at this I would suggest looking at the format property, or the decimal places property, but I'm not really sure what your problem is so I'm not sure how much help I can be.
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    To format your calculation, just use a format function:

    EG:

    Format(YourCalculation, "#,##0.00")
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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