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

Ignore repeated names

Status
Not open for further replies.
deectc

deectc

Instructor
Joined
Nov 8, 2001
Messages
1
Location
GB
I am trying to produce labels for students exam results, however if student sits more than 1 exam more than 1 label is being printed. How can I restrict to 1 label per student???
 
Sort by date Sort by votes
Did you try using the DISTINCT clause? Terry M. Hoey
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cassiopeia
  • Locked
  • Question Question
Repeated values in query
Replies
4
Views
171
sxschech
sxschech
irethedo
  • Locked
  • Question Question
Is updating names in a table easier with a query or code?
Replies
2
Views
260
irethedo
irethedo
teach314
  • Locked
  • Question Question
Getting row numbers in a query having repeated values
Replies
4
Views
191
teach314
teach314
teach314
  • Locked
  • Question Question
question about RANKING records in a table with repeated values
Replies
5
Views
417
teach314
teach314
georgesOne
  • Locked
  • Question Question
Need variable field names in SQL query
Replies
5
Views
247
georgesOne
georgesOne

Part and Inventory Search

Sponsor

Back
Top