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!

Duplicate Detail rows

Status
Not open for further replies.
hermantb

hermantb

Programmer
Aug 30, 2002
18
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
Transpose Columns into Rows?
Replies
1
Views
316
hilfy
hilfy
J
  • Locked
  • Question
New page before when a detail section last on page.
Replies
1
Views
388
hilfy
hilfy
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
395
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
250
Cpreston
Cpreston
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
290
Paulo R
Paulo R

Part and Inventory Search

Sponsor

Back
Top