Filter a query

[Guest]

Dear Sirs
I have a query where in one field could stand: Cuentas autodirigidas,
Cuentas gestionadas, Simulación, BIE30.
I would like to see only the records from: Cuentas autodirigidas, Cuentas
gestionadas, Simulación - and not from BIE30

 

[gibsonsgman]

Dear Sirs
I have a query where in one field could stand: Cuentas autodirigidas,
Cuentas gestionadas, Simulación, BIE30.
I would like to see only the records from: Cuentas autodirigidas, Cuentas
gestionadas, Simulación - and not from BIE30

use the criteria field in the query design view
for example: enter the following text in the criteria to match your
case you described:

Not Like ("BIE30*")

In case you don't know what it is, the '*' at the end is a wildcard
character in case you have extra spaces at the end of the field. but
this line placed in the criteria field will give you all values in that
field that do not equal "BIE30"

 

[fredg]

Dear Sirs
I have a query where in one field could stand: Cuentas autodirigidas,
Cuentas gestionadas, Simulación, BIE30.
I would like to see only the records from: Cuentas autodirigidas, Cuentas
gestionadas, Simulación - and not from BIE30

As criteria on that field:
Not "BIE30"