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

Need 1st record of a group but not if repeated. 1

Status
Not open for further replies.

gallobask

Technical User
Jun 25, 2009
48
US
I have to create a report looking for the first surgery case in a room. I can get that easily enough, but if a surgeon is the first doc working in 2 different rooms I only want his earlier start case.

Example: Grouping on OR Room (Using a variable to count the records and suppressing anything > 1)
OR 1 07:30 Dr. White
OR 2 07:15 Dr. Red
OR 3 08:00 Dr. Blue
OR 4 07:30 Dr. Black
OR 5 08:30 Dr. Red
OR 6 07:30 Dr. Brown

So I only want the 07:15 case for Dr. Red to show. How can I suppress the second Dr Red record?

Thank you!

 
There are no suppressions (that's what I loved about getting the data this way)and the selection is what I posted. I think I am going to rebuild the report from scratch and see what happens to the record selection along the way.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top