Hi. I've made a record on a table which would be used as a comparison to other records in the table. for example..
table:
recordID 100001,Company Name
recordDI 999999,Company Name
i want to compare record 1000001's Company Name with record 9999999's Company name. How do I do that? thanks!
by writing some SQL.
What is the database that you are working on ?
im using ADO db. and yeah iknow its by using sql.:( sarcasm hurts lol
Here are some SQL terms for you to look up...
Group By Clause with a Having Clause
Order By Clause
Now, there are several ways to accomplish what you want to do...
You can group by on the company name with a count of company name having that count > 1 so you only pull those company's that have duplicates, or you can order by company name and run through the resulting rs comparing previous record to current record and if a duplicate is found, then do whatever...
Good Luck
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.