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!

Top 5

Status
Not open for further replies.
jasonhuibers

jasonhuibers

Programmer
Sep 12, 2005
290
CA
I am using top 5 based on amount column... I have 20 columns where the Amount is 0, in this case the top 5 isno longer top 5 but rather showing Top 5 of Amount... Which makes sense but I need to show only the top 5 in this case or only 5... How can I do this if the Amount column is all the same value?
 
Sort by date Sort by votes
Please clarify. What are you after?

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

nerdygirlgear
  • Locked
  • Question
Formula evaluating a list of 50 values that are strings.
Replies
1
Views
118
1tufgt
1tufgt
TryingToLearn101
  • Locked
  • Question
To prompt user to either do top N or bottom N Group Sort
Replies
3
Views
65
briangriffin
briangriffin
timhans
  • Locked
  • Question
How to get top 2 variance
Replies
0
Views
35
timhans
timhans
LZido
  • Locked
  • Question
Grouping by 24 hour time periods from 8:00:00 - 7:59:59 1
Replies
6
Views
90
LZido
LZido
neronikita
  • Locked
  • Question
filtering a grouped report to show top 3 by each state in each group
Replies
5
Views
74
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top