Thread: filter
View Single Post
  #1  
Old May 13th, 2010, 08:43 PM posted to microsoft.public.access.queries
Simon L
external usenet poster
 
Posts: 22
Default filter

I have a database that have two fields: Tier and S Tier. There are different
values in these fields (e.g. Tier:1, 2, 3, 4... S Tier: 1, 2, 3, NC, DME...).
What I want is to only look at those records where Tier and S Tier are
different. In other words, if a record has "1" in both Tier and S Tier
fields, I want to filter that record out. Can you help?

Thanks!