Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    20

    Unanswered: Quick Formatting Number Question

    Okay, what do I need to add.

    We have the following expression:

    Formatting: Format([qryHhldSum]![SumofHousehold count],"Standard")

    I want the number to end up as 123,456 and that's it. As it stands now, what we're getting is 123,456.00.

    I tried adding a comma after "Standard" and then a zero (as if to say no decimal places), but didn't work.

    What am I missing.

    Thank you!!
    Dante

  2. #2
    Join Date
    Feb 2004
    Posts
    137
    Try this:

    Format([qryHhldSum]![SumofHousehold count],"#,###")

  3. #3
    Join Date
    Aug 2003
    Posts
    20

    Thank you

    Thanks Matt for your help...so simple is painful. That has really helped!

    Cheers,
    Dante

Posting Permissions

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