Inputting Yes or No for Duplicate Names HELP!!

[Crawfordrider33]

Hi Everyone!



I'm looking to write an update query that will input yes or no for names that are duplicated in a table. What would this update query look like?! Please help!!

Thank you,

[orange]

Why do you have duplicates? Why an update query?
Can you tell us more about this application in plain English?

[Crawfordrider33]

I'm working with a list of investors that have multiple properties so I'm trying to identify the ivestors that are new. So if there is only 1 investor name I want to identify them in a column I have labeled "New Investor" with a Yes. If there multiple properties with the same investor name I want to label the investor name with a "No" indicating that they are not a new investor.

[NoellaG]

And what would you do after a month when the 'new' investor purchases a second property? I would suggest you review your database structure; you should at least have 2 tables: tblInvestors and tblProperties

[orange]

Your data structure is suspect. If 1 investor can own 1 or many Properties, then this business fact is identifying a 1 to Many relationship between Investor and Property. As noella says --Your tables should at least show

    1 ----------> Many
Investor -->Property

I think you would benefit greatly by working through this tutorial from RogersAccessLibrary.