Select Values that exist more than once

[gerhardl]

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

[swuehl · Accepted solution]

It should be possible to create a button with a select in field action.

Use

[Account No]

as field, and as search string

='=count(POLICYFIELD)>1'

(as stated, including the single quotes and two equal signs).

[gerhardl]

Nice. Thanks