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 gkittelson 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
Dec 11, 2003
62
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
presenting all records that meet a condition plus the first record only that does not meet the cond
Replies
1
Views
625
lbass
lbass
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
644
sal21
sal21
lm1340
  • Locked
  • Question
How to only get records that have data in at least one of many tables 1
Replies
2
Views
645
lm1340
lm1340
Almie
  • Locked
  • Question
Display record with identical field data
Replies
2
Views
130
hilfy
hilfy
DJWheezyWeez
  • Locked
  • Question
Dynamic parameter not showing every record 1
Replies
1
Views
104
PeterDimitrov
PeterDimitrov

Part and Inventory Search

Sponsor

Back
Top