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

Need the highest dollar value rows

Status
Not open for further replies.
wanzek1

wanzek1

Technical User
Jun 13, 2012
79
US
I am working on a report that has hundreds of lines of data. I would like to return only the rows where a field (complex if then else formula) is one the highest 10 rows.

Is this possible? I am kind of hoping I can do it through a suppression formula.
 
Status
Not open for further replies.

Similar threads

cursedkorok
  • Locked
  • Question
Transpose Columns into Rows?
Replies
1
Views
229
hilfy
hilfy
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
296
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
182
Cpreston
Cpreston
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
409
doodledump
D
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
107
BradCustom
BradCustom

Part and Inventory Search

Sponsor

Back
Top