By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Select Query Help

P: n/a
I have a tbl with a dealernumber field and zipcode field. Each dealer
number can have multiple zipcodes attached to it. I do I select just
one instance of the dealer number and all of the zipcodes attached to
that dealer number as well as all the other fields. Thanks.

May 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
fo*******@martecgroup.com wrote:
I have a tbl with a dealernumber field and zipcode field. Each dealer
number can have multiple zipcodes attached to it. I do I select just
one instance of the dealer number and all of the zipcodes attached to
that dealer number as well as all the other fields. Thanks.

I have little idea how you are selecting the records. Let's say you are
using a combo. You could select the dealernames and present them in
sorted order. So you don't get duplicate names, the SQL should have the
word DISTINCT. From View/SQL your statement might be
Select distinct dealernumber from table order by dealernumber

Now when you click on that, you could set a filter to records in the
form with something like
Me.Filter = "dealernumber = " & Me.ComboBox
Me.FilterOn = True
May 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.