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.