Truncate right two digits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I truncate the rightmost two digits of every data field in my Access
table?
 
Bill,

If I understand you correctly, you could make and run an Update Query to
update eah such field to...
[TheNumber]\100

If that doesn't do the trick, please post back with more details and
examples.
 
THANK YOU!

Steve Schapel said:
Bill,

If I understand you correctly, you could make and run an Update Query to
update eah such field to...
[TheNumber]\100

If that doesn't do the trick, please post back with more details and
examples.

--
Steve Schapel, Microsoft Access MVP


Bill_S said:
How do I truncate the rightmost two digits of every data field in my Access
table?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Truncating Linked ODBC field names 1
Truncate Memo field in Union Query 6
truncated dated 1
Truncating Numbers in Queries 7
How I import data without truncating zaro in the beginning 1
How can I remove the trailing "1" from a worksheet. 2
SetOption in Access 2007 2

Back
Top