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

display most recent record 1

Status
Not open for further replies.
giggles7840

giggles7840

IS-IT--Management
Mar 8, 2002
219
US
i have 3 records. The user only wants to see one of those 3 records based on the most recent date. is there a way to have the report display just the most recent record? the other 2 are not necessary for the report.
 
Sort by date Sort by votes
You can sort by date descending and then place all the fields in the group header section.

-LB
 
Upvote 0 Downvote
That wont work if one of the date fields is blank.
 
Upvote 0 Downvote
nevermind yes it does. i wasnt paying attention to the asc/dec.
 
Upvote 0 Downvote
oh geex that was way easier than i was trying to make it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hg05
  • Locked
  • Question
Crystal report chart display
Replies
0
Views
359
hg05
hg05
MusicMan123
  • Locked
  • Question
Record Selection Formula Help
Replies
0
Views
263
MusicMan123
MusicMan123
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
337
lbass
lbass
nerdygirlgear
  • Locked
  • Question
Selecting one Record in Group for Sum
Replies
10
Views
684
nerdygirlgear
nerdygirlgear
rickm140
  • Locked
  • Question
last sale (or most recent sale) greater than zero
Replies
1
Views
172
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top