[AccessD] Replace/delete first 4 characters

Kaup, Chester Chester_Kaup at KinderMorgan.com
Mon Nov 5 14:40:43 CST 2007


For example if your data is in table1 and field1 use this function

Mid([Table1]![Field1],5,7)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sheri Hixson
Sent: Monday, November 05, 2007 2:22 PM
To: accessD at databaseadvisors.com
Subject: [AccessD] Replace/delete first 4 characters

I have a column in a table that contains info as shown below:

 

123 123.456

123 123.456

410 410.435

555 555.123

789 789.678

910 910.321

 

The first 3 characters are duplicated in 5,6,7. How do I remove the
first
three characters, and the space, from each record in this column so that
the
results would be:

 

123.456

123.456

410.435

555.123

789.678

910.321

 

Any help would be appreciated!

 

Thanks,

 

Dee

 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list