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

Listbox- Limiting list

Status
Not open for further replies.
ianbar

ianbar

Technical User
Jan 10, 2003
69
GB
I have a list box which currently displays the returned product from a table. The problem is there's a lot of repeat enteries ie 10 of the same product has been returned, how can I limit it to one entery per product type?
 
Sort by date Sort by votes
In the rowsource of the listbox add DISTINCT after SELECT.

That should do it...

There are two ways to write error-free programs; only the third one works.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
357
DB_Bowes
DB_Bowes
nikademous
  • Locked
  • Question
List procedures in a module
Replies
2
Views
212
nikademous
nikademous
Triacona
  • Locked
  • Question
Genericise buttons and list calls 1
Replies
1
Views
221
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Combo Finder does not find record after Not In List procedure
Replies
1
Views
182
zandsc1
zandsc1
Dophia
  • Locked
  • Question
Not in List problem with query source
Replies
0
Views
166
Dophia
Dophia

Part and Inventory Search

Sponsor

Back
Top