How to convert into integer 1

[bnageshrao]

I have a column where the values have decimal places like 320.0, 734.0, 850.0, 1200.0 etc which I want to make it as integer only like 320, 734, 850, 1200 etc. Can we replace the exsiting values by using some function, any help is highly appreciated.

 

[dhookom]

Set the Format and Decimals properties of the text boxes on your forms and reports to not display decimals.


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]

 

[bnageshrao]

Wow, It worked, Thanks a lot.