2 Replies Latest reply: Jan 17, 2013 9:36 AM by Gerhard Laubscher RSS

    Select Values that exist more than once

    Gerhard Laubscher

      Hi There,

       

      How can I select all values in a certain field, that appear more than once in a particular table?

       

      I have a key field (appears in 4 different tables) called [Account No]. One table shows all accounts with Funeral Policies. Some accounts have more than one policy.

       

      I want to create a button/bookmark (or yes/no list box) that then selects all accounts that have more than one policy.

       

       

      Thanks,

       

      Gerhard