Hello I have a query with two fields, one is the tax id and the other is a flag. The flag will either be "Valid" or "Not Valid", I know I have tax-id records with both "Valid" and "Not Valid". Is there a way I can identify tax id records with both "Valid" and "Not Valid" fields?
Last edited by jgomez; 01-27-2014 at 02:42 PM.
Do you mean everything else in the records is identical excelp the flag?
If posting code please use code tags, see here.
Yes, I think I got it. I will do a group by query then write an IIF query to see if the tax id records are >1. I'll run it and see if that works.
Nope that didn't work...
If the ID is unique then you should be able to identify the duplicates like this.
SELECT [IDField], Count([IDField])),
FROM [MyTable]
GROUP BY [IDField]
HAVING Count([IDField])>1
Thanks a bunch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks