Query Filter

[Guest]

I have a query where in one field are 4 posibilities to choose.
Say in that field is 1,2,3,4 written in.
I only want to seethe records for 1,2,3 in this query and not the 4
How does the criteria has to look?

 

[Rick Brandt]

I have a query where in one field are 4 posibilities to choose.
Say in that field is 1,2,3,4 written in.
I only want to seethe records for 1,2,3 in this query and not the 4
How does the criteria has to look?

<> 4

or
< 4

or
In(1, 2, 3)

 

[Guest]

Hi Rick,
doesn't work with your criteria.
I would like to see records 1,2,3, and not 4. (all numbers have of course a
name)

 

[Rick Brandt]

Hi Rick,
doesn't work with your criteria.
I would like to see records 1,2,3, and not 4. (all numbers have of
course a name)

A criteria of <> 4 will show all records where the value is anything except
a four.

A criteria of < 4 will show all records where the value is any numeric value
that is smaller than four.

A criteria of In(1, 2, 3) will return all records where the value is a 1, or
a 2, or a 3.

What exactly about the above don't work for you?

I don't understand the comment "all numbers have of course a name". Are you
saying that the values are not actually the numbers 1,2,3,4 but are
something else?

 

[Guest]

Sorry Rick
I thought it doen't matter, numeric or text. Sorry for the time I took from
you due to my silly mistake.
In my query 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

 

[Rick Brandt]

Sorry Rick
I thought it doen't matter, numeric or text. Sorry for the time I
took from you due to my silly mistake.
In my query 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

All of what I posted before is still valid except you would need quotes around
the values since they are text (using < would be unusual on text though).

<> "BIE30"