Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-11-2003, 01:59 AM   #1
tsnorgaard
Guest
 
Posts: n/a
Unhappy Remove Zero?!? Need help

Hi !
I need to remove the a zero in a table.
I know how to chage the type a data to numbers, bu my data includes also letters.

ex.

Tabel 1:
001
002
007
008
010
001a
002b
010a

Result:
1
2
7
8
10
1a
2b
10a

Please help me Im going out of my mind.

Thomas

  Reply With Quote
Old 08-11-2003, 02:38 AM   #2
namliam
The Mailman - AWF VIP
 
Join Date: Aug 2003
Location: Amsterdam/The Netherlands
Posts: 11,415
Thanks: 0
Thanked 805 Times in 790 Posts
namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light
Try using the "HARDTRIM" function created by Jason in this thread and modifying it a bit.

Or you can do a series of update queries replacing 0*:
UPDATE Table1 SET Naam = Mid$([Naam],1)
WHERE Naam Like "0*";
Run this query as many times as you need it to remove all (starting) zero's. --Note For some reason i cant run this query allthough it should work.

Regards

The Mailman

P.S. Removing the leading zero's WILL be the start off sorting problems in your Table with this field.
1
1a
10
10a
100
100a
2
2a

Will be the result of an assending order by.... Just a reminder...
namliam is offline   Reply With Quote
Old 08-11-2003, 03:27 AM   #3
tsnorgaard
Guest
 
Posts: n/a
Thanks mate !!

Thomas

  Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 07:54 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World