Parmeters

[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

 

[John Spencer]

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

 

[Ron2006]

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