How do I remove the first 8 characters from a Microsoft Access database field?
Posted
by Gavin O'Brien
on Stack Overflow
See other posts from Stack Overflow
or by Gavin O'Brien
Published on 2010-04-19T16:20:19Z
Indexed on
2010/04/19
16:23 UTC
Read the original article
Hit count: 181
Hi, I've got an Access '07 database that imports data from text files. The problem is one of the fields that is taken in comes with a date value before a place value that I don't need. For example, the field comes in like so: 01012010DUBLIN whereas I need it to just display DUBLIN.
I'm stumped on this and any help would be greatly appreciated
Thanks.
© Stack Overflow or respective owner