Formatting a Numeric field 1

[zimmer9]

I have a table that contains a numeric field titled "SharesAmount" which for reporting purposes should display as a max of 10 integers followed by a decimal point and 3 decimal positions.

For ex: On 1 record, I need to display a value of 2321.820 (with no editing characters such as dollar signs or commas). This field appears in the table as 2321.82000.

I defined this field in the table as follows:

Data Type: Number

Field Propertiesecimal
Format:Fixed
Precision:18
Scale:5
Deimal Places:5

In a query under design view, this field appears as a calculated field because the user wanted to see either the value represented by SharesAmount or another field if SharesAmount was empty. The values of the 2 table fields in the query's calculated field are mutually exclusive. The field appears in the query grid as follows:

Check/Cert Amount: nz([SharesAmount],[CashBalance])

What value should I place in the Field Properties Format
for this field to display a value such as 2321.820 ?

 

[PHV]

#.000

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Or perhaps #########0.000 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244