Update

[nl]

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

 

[Guest]

why not run a query that multiplies it all by 100?

 

[Van T. Dinh]

.... 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)