B
Bill_S
How do I truncate the rightmost two digits of every data field in my Access
table?
table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dlw
if the data are whole numbers (no decimals), then int([data]/100)
S
Steve Schapel
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.
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.
B
Bill_S
THANK YOU!
B
Bill_S
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?