Searching for '&' in Field

  • Thread starter Thread starter John Parkinson
  • Start date Start date
J

John Parkinson

I have a database that I need to clean up. One of the
fields called 'PARCEL' contains property lot numbers.
Several hundred of the records contain 'PARCEL' data that
carrys two lot number (89 & 90...or 210 & 211). How can I
set up a query that will 'search' these records? I know
that the 'search and replace' function can find these
records but I am unsure how to set this up in a query.

Thanks in advance.

John Parkinson
 
Set up a calculated field in the query.

Expr1: InStr([Parcel], "&")

and set the criteria to
 
Ahhhhh, I see. So the '>0' forces the InStr to search the
entire field instead of looking in one ceratin place in
the string.

Thank you very much Wayne!!

John
-----Original Message-----
Set up a calculated field in the query.

Expr1: InStr([Parcel], "&")

and set the criteria to
0
Click to expand...

--
Wayne Morgan
Microsoft Access MVP


I have a database that I need to clean up. One of the
fields called 'PARCEL' contains property lot numbers.
Several hundred of the records contain 'PARCEL' data that
carrys two lot number (89 & 90...or 210 & 211). How can I
set up a query that will 'search' these records? I know
that the 'search and replace' function can find these
records but I am unsure how to set this up in a query.

Thanks in advance.

John Parkinson
Click to expand...


.
Click to expand...
 
Back
Top