Find and replace ?
in [General]
|
From: Ken on 2 Jul 2008 12:24 I converted a database and it changed all single quotes to question marks. I need to do a find and replace, but when I put in ? it thanks it's a wild card. How do I do a find and replace to look for a question mark?
From: KARL DEWEY on 2 Jul 2008 12:50 WHERE InStr([YourField],Chr(63)) >0 -- KARL DEWEY Build a little - Test a little "Ken" wrote: > I converted a database and it changed all single quotes to question marks. I > need to do a find and replace, but when I put in ? it thanks it's a wild > card. How do I do a find and replace to look for a question mark?
From: Ken on 2 Jul 2008 13:32 I have opened the table and need to enter this in the Find and Replace tool, not a query - Thanks. "KARL DEWEY" wrote: > WHERE InStr([YourField],Chr(63)) >0 > -- > KARL DEWEY > Build a little - Test a little > > > "Ken" wrote: > > > I converted a database and it changed all single quotes to question marks. I > > need to do a find and replace, but when I put in ? it thanks it's a wild > > card. How do I do a find and replace to look for a question mark?
From: Douglas J. Steele on 2 Jul 2008 13:53 You're far better off using an Update query than Find and Replace. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Ken" <Ken(a)discussions.microsoft.com> wrote in message news:AE39251D-53DB-4095-8455-4E3D93013012(a)microsoft.com... >I have opened the table and need to enter this in the Find and Replace >tool, > not a query - Thanks. > > "KARL DEWEY" wrote: > >> WHERE InStr([YourField],Chr(63)) >0 >> -- >> KARL DEWEY >> Build a little - Test a little >> >> >> "Ken" wrote: >> >> > I converted a database and it changed all single quotes to question >> > marks. I >> > need to do a find and replace, but when I put in ? it thanks it's a >> > wild >> > card. How do I do a find and replace to look for a question mark?
From: Ken on 2 Jul 2008 14:02 But I need the ability to leave question marks where they are appropriate. "Douglas J. Steele" wrote: > You're far better off using an Update query than Find and Replace. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Ken" <Ken(a)discussions.microsoft.com> wrote in message > news:AE39251D-53DB-4095-8455-4E3D93013012(a)microsoft.com... > >I have opened the table and need to enter this in the Find and Replace > >tool, > > not a query - Thanks. > > > > "KARL DEWEY" wrote: > > > >> WHERE InStr([YourField],Chr(63)) >0 > >> -- > >> KARL DEWEY > >> Build a little - Test a little > >> > >> > >> "Ken" wrote: > >> > >> > I converted a database and it changed all single quotes to question > >> > marks. I > >> > need to do a find and replace, but when I put in ? it thanks it's a > >> > wild > >> > card. How do I do a find and replace to look for a question mark? > > >
|
Next
|
Last
Pages: 1 2 Prev: Multiple users, how can users view only their entries Next: Partial Matching issue |