AppleWorks Database Question

[Benjamindaines]

I have a database of names with a number associated to them, is there a way to run a query to look at all the numbers and show all the entries with duplicate numbers?

 

[MisterMe]

... is there a way to run a query to look at all the numbers and show all the entries with duplicate numbers?

Have you tried the Organize>Match Records ... menu selection?

 

[Benjamindaines]

Have you tried the Organize>Match Records ... menu selection?

That doesn't do what I want it to

 

[CanadaRAM]

One way is to export the records to a spreadsheet, Sort by "the number" and write a simple calculation in a blank column (lets say "the number" is in col A): IF(A2=A1,"Yes", "No")
or something similar. This will flag your duplicates

Just remember, the results of this calc will change if you re-sort, so you want to either copy and paste the values only into a new column, or just scan down the list manually and mark them.