Query Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Assuming you're using the graphical query builder, put the following as your
criteria:
 
Klaus:

In the Account Number column's criteria row in query design view put:
"43001000-0000" And [Account Number] <> "43001000-8000"
Click to expand...

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
 
Back
Top