R
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?
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?