Hi Chris (Ha! You used your name!),
> I have to check a DB to see if a record is a duplicate.
> The main thing I am checking is first and last name.
> These name often have apostrophe's!!!! How in the
> world am I going to use findfirst or seek this way?
I wouldn't. Instead, I'd just use something like this:
SELECT fieldname, Count(fieldname) AS dups
FROM tablename
GROUP BY fieldname
HAVING (Count(fieldname) >= 2)
ORDER BY Count(fieldname) DESC;
This will return all the actual values for fieldname that duplicates
exist within. Then create an interface that returns records where
fieldname = each fieldname value. That oughtta make it a lot easier
for you.
Regards,
Shawn K. Hall
http://12PointDesign.com/
http://ReliableAnswers.com/
'// ========================================================
As it is said of the greatest liar that he tells more
truth than falsehoods, so it may be said of the worst
man that he does more good than evil.
-- Samuel Johnson
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
