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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing group if less than two records 1

Status
Not open for further replies.

5lights

MIS
Nov 19, 2003
53
US
My report is grouped by DATE & STAFF, & shows each EVENT assigned.
How do I show only those STAFF with more than one EVENT on a DATE?
 
If date is your outer group (Grp#1) and you also have an inner group on {table.staff} (Grp#2), then go to report->edit selection formula->GROUP and enter:

count({table.event},{table.staff}) > 1

This will display only those staff with more than one event on the particular date.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top