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!

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

Group Record Suppress 1

Status
Not open for further replies.
elead

elead

Technical User
Apr 20, 2001
38
US
I have 2 groups on the report
Date, ID
I want to suppress all except the minimum value for the record
If {tblCallTrak.LCTime} > Minimum({tblCallTrak.LCTime}) Then True

This supresses all the records except the minimum, how to I apply this criteria to the records in each group??
 
Sort by date Sort by votes
...{tblCallTrak.LCTime} > Minimum({tblCallTrak.LCTime},{GroupingField})...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
401
bbranco
bbranco
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
571
SarahSCPDAdmin
SarahSCPDAdmin
G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
155
george1610
G
petejigsaw
  • Locked
  • Question
Suppress group if it contains both specified detail records
Replies
3
Views
293
lbass
lbass
MusicMan123
  • Locked
  • Question
Record Selection Formula Help
Replies
0
Views
248
MusicMan123
MusicMan123

Part and Inventory Search

Sponsor

Back
Top