query criteria

[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

 

[Jeff Boyce]

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

 

[Jasper Recto]

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

 

[Jeff Boyce]

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

 

[John Spencer]

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

 

[Jeff Boyce]

Excellent point!

Jeff

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