Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excluding all counts less than 2

Status
Not open for further replies.

techgamma

Technical User
Dec 18, 2001
5
US
I have created a report that adds a number of different attributes per person, and displays how many of those attributes that person had. But I do not want people showing up that have less that 2 attributes (they only have 1 attribute or zero attributes).

So far I have :

Code:
If (Count of Stud.Action) < 2 Then &quot; &quot;

But it does not wipe out those people with less than two attributes ...

Any assistance would be greatly appreciated ...

Thanks ...
 
Hi,

Use this as your selection formula.

{Stud.Action)}>2

This will eliminate all records that have 2 or less attributes.

Nuffsaid.
 
Depends on what's in your field. Actual attributes or # of attributes.

Nuffsaid
 
I got it, I created an expert stating to oly show the Count of Stud.Action is greater than or equal to 2.00. It works, so I can't complain.

Thanks for your help though ...

Techgamma
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top