Not Like Query Removes Duplicate Records?

[Rothman]

I have a table of about 600 records that's like so:

REGION_NUM AMT FY_BOOK PIN TRNS_DATE PROJ_STUS CODE
10 10000 2008 001623 11/30/2008 ACTIVE

I've run a make table query to remove certain records based on a list of pin
numbers. To do this, I used a "not like" string (not like 134985 and not
like 139483 and not like...).

When I went over the new list of pins this generated, I found that
"duplicate" records had been removed from the query results along with the
records that I wanted to be excluded (those in the not like string).

The "duplicates" are legitimate...two identical records are supposed to
exist where Access removed one when I ran the query.

What's going on here?

 

[KARL DEWEY]

Check the query you used for DISTINCT or a totals query.