Eliminating data that starts with an astericks

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I am working with data where the records that were no longer valid were
altered to have and astericks in front of the last name.

Since an * is a wild card, I am at a loss on how to eliminate these records
from my query output.

Jennifer
 
Field: YourField
Criteria: NOT LIKE "[*]*"

Or you may be able to use
Criteria: Like "[!*]*"

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
I would recommend that you add an Archive Yes/No field and not use the
astericks.
--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
Asc([YourField])
Criteria <>42
--
KARL DEWEY
Build a little - Test a little


Jennifer said:
I am working with data where the records that were no longer valid were
altered to have and astericks in front of the last name.

Since an * is a wild card, I am at a loss on how to eliminate these records
from my query output.

Jennifer
 
This worked too!

John Spencer said:
Field: YourField
Criteria: NOT LIKE "[*]*"

Or you may be able to use
Criteria: Like "[!*]*"

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
I am working with data where the records that were no longer valid were
altered to have and astericks in front of the last name.

Since an * is a wild card, I am at a loss on how to eliminate these records
from my query output.

Jennifer
 
I would agree, but I don't control the data source, just work with the
extracts sent to me.

Your answer worked perfectly!

Thanks,
Jennifer

KARL DEWEY said:
I would recommend that you add an Archive Yes/No field and not use the
astericks.
--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
Asc([YourField])
Criteria <>42
--
KARL DEWEY
Build a little - Test a little


Jennifer said:
I am working with data where the records that were no longer valid were
altered to have and astericks in front of the last name.

Since an * is a wild card, I am at a loss on how to eliminate these records
from my query output.

Jennifer
 
If they are sent to you, you have full control over how you store the data.
--
KARL DEWEY
Build a little - Test a little


Jennifer said:
I would agree, but I don't control the data source, just work with the
extracts sent to me.

Your answer worked perfectly!

Thanks,
Jennifer

KARL DEWEY said:
I would recommend that you add an Archive Yes/No field and not use the
astericks.
--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
Asc([YourField])
Criteria <>42
--
KARL DEWEY
Build a little - Test a little


:

I am working with data where the records that were no longer valid were
altered to have and astericks in front of the last name.

Since an * is a wild card, I am at a loss on how to eliminate these records
from my query output.

Jennifer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top