AppleWorks Database Question

Discussion in 'Mac Apps and Mac App Store' started by Benjamindaines, Apr 29, 2007.

  1. Benjamindaines macrumors 68030

    Benjamindaines

    Joined:
    Mar 24, 2005
    Location:
    A religiously oppressed state
    #1
    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?
     
  2. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #2
    Have you tried the Organize>Match Records ... menu selection?
     
  3. Benjamindaines thread starter macrumors 68030

    Benjamindaines

    Joined:
    Mar 24, 2005
    Location:
    A religiously oppressed state
    #3
    That doesn't do what I want it to
     
  4. CanadaRAM macrumors G5

    CanadaRAM

    Joined:
    Oct 11, 2004
    Location:
    On the Left Coast - Victoria BC Canada
    #4
    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.
     

Share This Page