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

Select Every 5th Record 1

Status
Not open for further replies.
BradW

BradW

IS-IT--Management
Nov 30, 2000
126
US
I need to write a report that selects every 5th record from a data set, and need a hand with the formula to do this selection.

Thanks in advance for all help!

 
Sort by date Sort by votes
You could do this by suppressing all but every 5th record. Go to the section expert->details->suppress->x+2 and enter:

remainder(recordnumber,5) <> 0

-LB
 
Upvote 0 Downvote
Perfect, so simple and yet so elegant. I appreciate the quick answer, you made my day.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Select Expert
Replies
2
Views
282
john432
john432
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
502
mmck1964
mmck1964
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
481
Cpreston
Cpreston
inkbird01
  • Locked
  • Question
Filters &gt; Record Selection for dates between
Replies
4
Views
370
pmax9999
pmax9999
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
329
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top