This content has been marked as final. Show 2 replies
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.