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

Only want to show One record and not duplicates

Status
Not open for further replies.
Newbie69

Newbie69

IS-IT--Management
Mar 2, 2002
5
US
I ahve a list of numerous ID's and I want to only show the first listing of that ID. But I still want to use the duplicates in calculations
 
Sort by date Sort by votes
One option is to Group by ID, place the fields of the
first record in the group header, and suppress the detail section.

Cheers,
- Ido ixm7@psu.edu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
241
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
432
hilfy
hilfy
socalvelo
  • Locked
  • Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
321
socalvelo
socalvelo
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
224
hilfy
hilfy
CodeWell
  • Locked
  • Question
Crystal Reports RPTR Format Not Available
Replies
2
Views
267
CodeWell
CodeWell

Part and Inventory Search

Sponsor

Back
Top