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

Duplicate Detail rows

Status
Not open for further replies.
hermantb

hermantb

Programmer
Joined
Aug 30, 2002
Messages
18
Location
US
Is there a way to return distinct rows only in the detail lines of a report?
 
Sort by date Sort by votes
No, there isn't.
You have to make group, and place all needed fields from details in group header or footer, then suppress details section.

Jadwiga.
 
Upvote 0 Downvote
You can select Database->Select Distinct Records.

Not sure if that's what you need.

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

Similar threads

cursedkorok
  • Locked
  • Question Question
Transpose Columns into Rows?
Replies
1
Views
723
hilfy
hilfy
J
  • Locked
  • Question Question
New page before when a detail section last on page.
Replies
1
Views
848
hilfy
hilfy
Cpreston
  • Locked
  • Question Question
Only Select certain rows
Replies
7
Views
984
Cpreston
Cpreston
Cpreston
  • Locked
  • Question Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
681
Cpreston
Cpreston
Paulo R
  • Locked
  • Question Question
CR Running Total distinct count duplicates
Replies
9
Views
858
Paulo R
Paulo R

Part and Inventory Search

Sponsor

Back
Top