Parmeters

  • Thread starter Thread starter ThomP
  • Start date Start date
T

ThomP

I have a list of people in a table with my Primary Key as a 6 digit number,
if that person visits again we put a "-A" after the 6 digit number. (IE
"######-A")

How can I create a query so I only get the people that have a "-a" or "-b"?

Thanks in advance
 
Use criteria of
LIKE "*[AB]"

That should return records where the primary key ends in the letter "A" or the
letter "B".

n
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
The above solution is IF the field you are calling "Primary Key" is
NOT an actual number but a text field. If the "-A" is showing up
because of some other logic on some form then you will have to use
whatever that logic is to display the dash-letter as the criteria for
the query.

Ron
 
Back
Top