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

Select 1st record

Status
Not open for further replies.
Monkey820

Monkey820

Technical User
Joined
Dec 11, 2003
Messages
62
Location
US
I have a subreport that produces dates for the group that meet the criteria of "bucket 1".

The problem is there may be more than one date that is in "bucket 1".
How do I supress all but the earliest date?

TIA,
Micky

CRW32 8.5
 
Sort by date Sort by votes
In the Report->Record selection->Group use something like:

{table.date} = minimum({table.date})

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dovl
  • Locked
  • Question Question
presenting all records that meet a condition plus the first record only that does not meet the cond
Replies
1
Views
978
lbass
lbass
sal21
  • Locked
  • Question Question
create report without database in vb 6.0 and recordset
Replies
0
Views
994
sal21
sal21
lm1340
  • Locked
  • Question Question
How to only get records that have data in at least one of many tables
Replies
2
Views
1K
lm1340
lm1340
Almie
  • Locked
  • Question Question
Display record with identical field data
Replies
2
Views
347
hilfy
hilfy
DJWheezyWeez
  • Locked
  • Question Question
Dynamic parameter not showing every record
Replies
1
Views
274
PeterDimitrov
PeterDimitrov

Part and Inventory Search

Sponsor

Back
Top