Charlotte Foust
cfoust at infostatsystems.com
Mon Aug 9 18:57:36 CDT 2004
No, that's one of the shortcomings of Access 2000. It works in queries in XP. Charlotte Foust -----Original Message----- From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] Sent: Monday, August 09, 2004 3:54 PM To: Access Developers discussion and problemsolving Subject: RE: [AccessD] Edit contents of field. On 9 Aug 2004 at 17:37, Mackin, Christopher wrote: > Replace() is only in Access 2000 and beyond, I'm using XP and can use > the syntax described by Arthur without issue. > Hmmm, interesting. Although Replace() is a function in A2K, it doesn't work in an A2K query. -- Stuart -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com