[AccessD] Edit contents of field.

Replace() is only in Access 2000 and beyond, I'm using XP and can use the syntax described by Arthur without issue.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Monday, August 09, 2004 5:23 PM
To: Access Developers discussion and problemsolving
Subject: RE: [AccessD] Edit contents of field.


On 9 Aug 2004 at 10:24, Arthur Fuller wrote:
> 
> replace([ColumnOfInterest],"-","")
> 
> Substitute the actual column name for [ColumnOfInterest]. Run the query
> and you're done.
> 

Sorry Arthur, but it doesn't work like that - you just get an error saying 
"undefined function replace"  

That's why I wrote the  function myReplace()

-- 
Stuart


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