Update

  • Thread starter Thread starter nl
  • Start date Start date
N

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:)
 
.... 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)
 
Back
Top