Select Buttong

[#1]

Hi ,

I am trying to create a button with Select in Field Action that will select Accounts with a set number of Assets.

I have used the expression below but cant seem to get it to work correctly.

  ='=count(DISTINCT [Serial #])>5 and count(DISTINCT [Serial #]=<10)'

Any suggestions would be gratefully recieved.

many thanks

Paul

[sujeetsingh]

Hello ,

Please express details of field and the selection you want .

If possible then give a sample .

[#3]

Thanks for the suggestion but I get error in expression.

[#4]

I have two tables one with my Accounts in and anothere with Assets in.  With a Account number as the key.

What I am trying to do is use a button to select all the Accounts that have between five adn ten assets (using a count of Serial # or i can use ROW ID).

[#5 · Accepted solution]

='=count(DISTINCT [Serial #])=1 or count(DISTINCT [Serial #])=2 or count(DISTINCT [Serial #])=3 or count(DISTINCT [Serial #])=4 or count(DISTINCT [Serial #])=5'

In the end I did this and it worked.