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