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 Chris 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
Nov 8, 2001
1
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
Repeated values in query
Replies
4
Views
82
sxschech
sxschech
irethedo
  • Locked
  • Question
Is updating names in a table easier with a query or code?
Replies
2
Views
92
irethedo
irethedo
teach314
  • Locked
  • Question
Getting row numbers in a query having repeated values 1
Replies
4
Views
69
teach314
teach314
teach314
  • Locked
  • Question
question about RANKING records in a table with repeated values 1
Replies
5
Views
132
teach314
teach314
georgesOne
  • Locked
  • Question
Need variable field names in SQL query 1
Replies
5
Views
84
georgesOne
georgesOne

Part and Inventory Search

Sponsor

Back
Top