How do I search for only question marks (?) in Access Databases?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are trying to clean up several large existing access databases where the
creaters marked things they think needed corrected with question marks at the
end of a word. How can we find, edit and replace or filter, edit and replace
these in a holistic fashion?
 
Thanks for your reply. I am not a strong query user and though less than
zero >0 makes sense it does not work in the table find option. Just so I
understand the logic behind the query, is Chr(63) a character code for "?"

KARL DEWEY said:
Add another output field to your query design view like this --
InStr([YourFieldName],Chr(63))

Use criteria >0 to find the question marks.

memphisarchivist said:
We are trying to clean up several large existing access databases where the
creaters marked things they think needed corrected with question marks at the
end of a word. How can we find, edit and replace or filter, edit and replace
these in a holistic fashion?
Click to expand...
Click to expand...
 
Yes it is the ASCII code for question mark.

You can determine the code for a character by using the following --
Asc([YourField) if you you are looking for that of the first
character.

Use Asc(Right(Left([YourField], x), y) to isolate a single character in a
field.

memphisarchivist said:
Thanks for your reply. I am not a strong query user and though less than
zero >0 makes sense it does not work in the table find option. Just so I
understand the logic behind the query, is Chr(63) a character code for "?"

KARL DEWEY said:
Add another output field to your query design view like this --
InStr([YourFieldName],Chr(63))

Use criteria >0 to find the question marks.

memphisarchivist said:
We are trying to clean up several large existing access databases where the
creaters marked things they think needed corrected with question marks at the
end of a word. How can we find, edit and replace or filter, edit and replace
these in a holistic fashion?
Click to expand...
Click to expand...
Click to expand...
 
I don't see why you needed to introduce Chr(63), Karl.

InStr([YourFieldName],"?") should work just as well. For that matter, you
could use LIKE "*[?]*"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


KARL DEWEY said:
Yes it is the ASCII code for question mark.

You can determine the code for a character by using the following --
Asc([YourField) if you you are looking for that of the first
character.

Use Asc(Right(Left([YourField], x), y) to isolate a single character in
a
field.

memphisarchivist said:
Thanks for your reply. I am not a strong query user and though less than
zero >0 makes sense it does not work in the table find option. Just so I
understand the logic behind the query, is Chr(63) a character code for
"?"

KARL DEWEY said:
Add another output field to your query design view like this --
InStr([YourFieldName],Chr(63))

Use criteria >0 to find the question marks.

:

We are trying to clean up several large existing access databases
where the
creaters marked things they think needed corrected with question
marks at the
end of a word. How can we find, edit and replace or filter, edit and
replace
these in a holistic fashion?
Click to expand...
Click to expand...
Click to expand...
 
*[?]* seems to work best in the table find option. Thanks to you both.

Memphis Archivist

Douglas J. Steele said:
I don't see why you needed to introduce Chr(63), Karl.

InStr([YourFieldName],"?") should work just as well. For that matter, you
could use LIKE "*[?]*"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


KARL DEWEY said:
Yes it is the ASCII code for question mark.

You can determine the code for a character by using the following --
Asc([YourField) if you you are looking for that of the first
character.

Use Asc(Right(Left([YourField], x), y) to isolate a single character in
a
field.

memphisarchivist said:
Thanks for your reply. I am not a strong query user and though less than
zero >0 makes sense it does not work in the table find option. Just so I
understand the logic behind the query, is Chr(63) a character code for
"?"

:

Add another output field to your query design view like this --
InStr([YourFieldName],Chr(63))

Use criteria >0 to find the question marks.

:

We are trying to clean up several large existing access databases
where the
creaters marked things they think needed corrected with question
marks at the
end of a word. How can we find, edit and replace or filter, edit and
replace
these in a holistic fashion?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top