criterion "question mark" in a new-builded query to show noise-records

[Medioman]

Hi everybody,

I have encountered a problem:
A couple of records in my database contain some noise.
They are represented by the following text: ? and ?????.
I want to filter out these noise (i.e. both question mark records) in a
separated query.
Therefore I filled the following criterion rule in the design window: Or
Like "[?]" Or Like "[??????]".
Instead of filtering out both concerning records, the query only shows the
record with one question mark, i.e. ?.
How can I realize that the record with ????? is also showed?

Medioman

 

[Tom Ellison]

Dear Medio:

How about:

LIKE "[?][?][?][?][?][?]"

(or NOT LIKE . . .)

Now, when you say:

LIKE "[??????]"

that is not nearly the same thing. Indeed it is identical to:

LIKE "[?]"

The list inside the brackets is a "set" of characters to seek. Repeating a
character already in the set does nothing.

But, fundamentally, why use LIKE at all?

Why not

= "?" OR ="??????"

Please count your question marks carefully. In you post you use 5 at first,
then 6, then 5 again.

Tom Ellison

 

[Medioman]

Thanks Tom, problem solved!
Yep, your last statement is right. I had to counter the question marks more
carefully... Sorry for the confusion!

Medioman

Dear Medio:

How about:

LIKE "[?][?][?][?][?][?]"

(or NOT LIKE . . .)

Now, when you say:

LIKE "[??????]"

that is not nearly the same thing. Indeed it is identical to:

LIKE "[?]"

The list inside the brackets is a "set" of characters to seek. Repeating
a character already in the set does nothing.

But, fundamentally, why use LIKE at all?

Why not

= "?" OR ="??????"

Please count your question marks carefully. In you post you use 5 at
first, then 6, then 5 again.

Tom Ellison

Hi everybody,

I have encountered a problem:
A couple of records in my database contain some noise.
They are represented by the following text: ? and ?????.
I want to filter out these noise (i.e. both question mark records) in a
separated query.
Therefore I filled the following criterion rule in the design window: Or
Like "[?]" Or Like "[??????]".
Instead of filtering out both concerning records, the query only shows
the record with one question mark, i.e. ?.
How can I realize that the record with ????? is also showed?

Medioman

 

[Van T. Dinh]

If you don't use "?" in the valid Field values, then you can use:

Like "*[?]*"

or if the question mark is always at the start then you can narrow down even
more:

Like "[?]*"

--
HTH
Van T. Dinh
MVP (Access)

Thanks Tom, problem solved!
Yep, your last statement is right. I had to counter the question marks
more carefully... Sorry for the confusion!

Medioman

Dear Medio:

How about:

LIKE "[?][?][?][?][?][?]"

(or NOT LIKE . . .)

Now, when you say:

LIKE "[??????]"

that is not nearly the same thing. Indeed it is identical to:

LIKE "[?]"

The list inside the brackets is a "set" of characters to seek. Repeating
a character already in the set does nothing.

But, fundamentally, why use LIKE at all?

Why not

= "?" OR ="??????"

Please count your question marks carefully. In you post you use 5 at
first, then 6, then 5 again.

Tom Ellison

Hi everybody,

I have encountered a problem:
A couple of records in my database contain some noise.
They are represented by the following text: ? and ?????.
I want to filter out these noise (i.e. both question mark records) in a
separated query.
Therefore I filled the following criterion rule in the design window: Or
Like "[?]" Or Like "[??????]".
Instead of filtering out both concerning records, the query only shows
the record with one question mark, i.e. ?.
How can I realize that the record with ????? is also showed?

Medioman