Pedro Janssen
pedro at plex.nl
Wed Dec 9 14:02:39 CST 2009
Hello David, looks good to me. I will try it out tomorrow at work. Thanks Pedro ----- Original Message ----- From: "David McAfee" <davidmcafee at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, December 09, 2009 6:58 PM Subject: Re: [AccessD] text between ( ) If this looks good: SELECT Concl, Mid([Concl],InStr(1,[Concl],"(")+1,InStr(InStr(1,[Concl],"("),[Concl],")")-2) AS Expr1 FROM YourTable WHERE (((Concl) Like "*(*)*")); you can do it like this: UPDATE YourTable SET YourTable.fldSelection = Mid([Concl],InStr(1,[Concl],"(")+1,InStr(InStr(1,[Concl],"("),[Concl],")")-2) WHERE (((YourTable.Concl) Like "*(*)*")); On Wed, Dec 9, 2009 at 8:13 AM, Pedro Janssen <pedro at plex.nl> wrote: > Dear Group, > > is it possible to filter out text between ( ) in a field [Concl] and place > only the text between ( ) in a new field [fldSelection], with a query. > > Thanks > > Pedro > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com