Share via

Use a custom format in Access to display easier to read millions

Anonymous
2013-09-03T20:40:40+00:00

I want to be able to type a number such as 4,628,915 and have Access return only 4.6 M. Is there any way this is possible to do in Access? I also want this to work for any other numbers.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2017-11-30T17:58:06+00:00

    Try this link

    http://datapigtechnologies.com/blog/index.php/formatting-access-queries-to-the-thousands-place/

    Design View - Property Sheet - General - Format: 

     $#,###,,.0\M

    (note you can use similar formating as Excel)

    4 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2013-09-03T21:04:16+00:00

    I don't know of a way to do this with a Format, but you could use an expression such as:

    ShowBigNum: Round([fieldname] / 1000000, 1) & " M"

    I'd store the actual number (probably in a Currency datatype field) for calculations, but you could use the above expression as either a calculated field in a Query or in the Control Source of a form or report textbox.

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-12-16T15:38:08+00:00

    You can use Format:

    Value = 4628915

    MegaNumber = Format(Value / 10 ^ 6, "0.0 \M")

    -> 4.6 M

    0 comments No comments