formate field

[carranz]

I have a field and its data type is (number)

and its field size: decimal
Precision: 4
Scale: 3
decimal places: Auto

value in the field
example: 3.45, 1.25, 0.324, 0.5, 0.45

I want this field to be truncated and only have 2 places
example of field value 34, 12, 03, 05, 04

Does anyone know how to do this

thanks in advance

 

[dhookom]

Do you want to do this for display only or do you want to update your data values?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[carranz]

update the values

 

[dhookom]

You won't be able to store values like 03, 05, 04 since leading zeros are not stored or normally displayed. You should be able to create an update query that updates your field using a calculation like:

Int([UnnamedField] * 10)


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]