How do you remove leading zero's in Microsoft Access?

		Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family
How do you remove leading zero's in Microsoft Access?

How do you remove leading zero's in Microsoft Access?

LinkBack

Thread Tools

Display Modes

#1 (permalink)

10-09-2007, 09:19 PM

Rupert

Junior Member

Join Date: Oct 2007

Posts: 2

How do you remove leading zero's in Microsoft Access?

I have imported data in Microsoft Access and some of the data has leading zero's. How can I remove these. I think you can use trim command in query but not sure how you do this

Links

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT -4. The time now is 09:25 PM.