Query Criteria

[Guest]

Dear Sirs
I would like to have a query criteria which is filtering out some records.
I.e. I would like to see every account number which is bigger than
43001000-0000 except the number 43001000-8000.
OK, the first I do know: I wrote the criteria:<>"43001000-0000" but how can
I exclude the number 43001000-8000 in the same criteria?
Can anyone help?
Thanks
Klaus

 

[Douglas J. Steele]

Assuming you're using the graphical query builder, put the following as your
criteria:

 

[Guest]

Klaus:

In the Account Number column's criteria row in query design view put:

"43001000-0000" And [Account Number] <> "43001000-8000"

where Account Number is the name of the field. You'll find that after
saving the query, if you reopen it in design view then Access will have moved
things around a bit, but it will work the same.

In SQL view it would be something like this:

SELECT *
FROM [Your Table Name Goes Here]
WHERE [Account Number] > "43001000-0000"
AND [Account Number] <> "43001000-8000";

Ken Sheridan
Stafford, England