Access 2000

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

Guest

One of my defined fields in my query is Part Number. Part Number is an
alpha/numeric field. Example: 05838H or 438-010HC
I would like to show all part numbers except those the end in H and begin
with 5.
Am thinking i can build an expression in criteria to do this? Have tired
for an hour now with now success. Am i right or is there another way to do
it?
thanks!!
 
Three ways that should work

PartNumber Like "[!5]*[!H]"

Or

PartNumber Not Like "5*" and PartNumber Not Like "*H"

OR

NOT (PartNumber Not Like "5*" OR PartNumber Not Like "*H")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
extract 3 numbers from a string 0
Help needed on zero filling the left and middle and concatenate 0
Criteria selects data both in and outside user defined date parame 4
Parameter Value in Crosstab Query 4
Make table query: [Enter 1] AS Test 1
Record Selection 2
split data problems 8

Back
Top