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

Last 5 entries..

Status
Not open for further replies.
Preetham16

Preetham16

IS-IT--Management
Dec 28, 2006
32
DE
Hello Guru's ...

Could anyone please help me with the formula where I can retrieve only the last 5 five Entries which is based on DATE.. For example a customer has 50 entries in 6 months but when I enter his Customer ID .. I want only the last 5 entries which he made may be in the last month. I have tried this BY Grouping with DATE in an Ascending order but i see list of 50 entries. But I would like to See only the LAST 5 Entries how do I filter this to only last 5. Every time they Execute the Report... it should show the last 5.

Regards
BVK
 
Sort by date Sort by votes
When you post that you found your own solution, please share your solution so that others can benefit from what you discovered. Otherwise the post becomes pointless.

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

Similar threads

J
  • Question
New page before when a detail section last on page.
Replies
1
Views
258
hilfy
hilfy
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
386
doodledump
D
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
164
Cpreston
Cpreston
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
177
BobSuruncle
BobSuruncle
GCL2007
  • Locked
  • Question
Extracting portion of field after last - 1
Replies
8
Views
148
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top