query criteria

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

I have a query that has column that needs to be filtered out.

How would I set the criteria for a column if I didn't want any records to
print if the specific column did not have the word 'CHARGE' in it. The
field can have other text in it or even part of the word so it must be able
to dissect the field.

Any suggestions?

Thanks,
Jasper
 
Jasper

Are you saying you want the row if the column/field doesn't have anything
like "CHARGE" in it?

First, are you absolutely certain that the field doesn't hold "RECHARGE" or
"CHARGED" or "CHARGELLINISTRO" or ...?

If you are sure, then I think you could use something like:

Not Like * & "CHARGE" & *

as the selection criterion under that field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
It might have any of those variations but I still would like to omit it from
the query.

How would you do that if it could be any of those options?

Thanks,
Jasper
 
Jasper

Please re-read my previous response...

Using the Not Like ... construction will find rows that do not have the
sequence "CHARGE" anywhere in the field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
One small point, the following may be appropriate it the field can be null.

FIeld: Whatever
Criteria: is Null or NOT Like "*Charge*"

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Excellent point!

Jeff

John Spencer said:
One small point, the following may be appropriate it the field can be
null.

FIeld: Whatever
Criteria: is Null or NOT Like "*Charge*"

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
Back
Top