| | |
|
|
|
Update |
|---|
| message from nl on 26 May 2004 |
I need to create a query that will delete the decimal
point only: Example: 309.54 update to: 30954 (no decimal
point)
All records have different dx. Just need to delete the
decimal point.
How can I do this????
Thank you:)
|
| anonymous replied to nl on 26 May 2004 |
why not run a query that multiplies it all by 100?
decimal
|
| Van T. Dinh replied to anonymous on 26 May 2004 |
... and wrap around it with Int() or CLng() so that if
there are more than 2 decimal places, it will still show
the trucated / rounded number after multiplied by 100.
HTH
Van T. Dinh
MVP (Access)
|
|
Archived message: Update (Microsoft Access Database)
