Access to 3 decimals -- Formatting
Posted on 2013-09-06
Good morning, experts:
I need some assistance with fixing a "formatting issue" in a query.
Tables -- background:
- I have a lookup table that contains the following (sample) records: A, B, C, D, E
- I have a data storage table which contains the following (sample) records: A, C, E
- For each record (A, C, E), I have associated values, e.g.: 10.381, 20.450, 30.974
Query -- background:
- I use a "left join" and link the lookup table to the data storage tables. This ensures that all five records (A, B, C, D, E) are listed in the query even though only 3 of them have numeric values.
Query Output (with 3 decimals including the .450 for "C"):
Now, instead of showing blank values for B and D, I've created the following expression:
Test: IIf([Field1] Is Null,"---",[Field1])
The revised query output now looks like this:
Query Output (with 3 decimals include the .450 for "C"):
As illustrated above, the display of the "20.450" has changed to "20.45". In the query, I'm using Field Properties (right-click on query field) and select Format = "Standard" and Decimal Place = "3".
My question... how I can force to still display 3 decimals while also including the "---"? Please keep in mind, 3 decimals are displayed if I just insert Field1 (w/o forcing to add the dashes).