Computing.Net > Forums > Office Software > Access Combo Query Filter

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access Combo Query Filter

Reply to Message Icon

Name: rayok
Date: October 9, 2004 at 12:03:50 Pacific
OS: XP
CPU/Ram: 2500/512
Comment:

Ive created a query with combo box so I can select the records to view via a drop down list as per

http://www.microsoft-accesssolutions.co.uk/query_filter.htm

The query I create will have multiple descriptions saying AS or A2, every single instance will appear in the combo drop down list e.g. there will be 20 A2's followed by 20 AS's and so on

How can I tell the combo box to ignore repeating entries - is there a setting in the properties ?

Thanks !

Techy n Welsh



Sponsored Link
Ads by Google

Response Number 1
Name: mdow
Date: October 26, 2004 at 09:20:24 Pacific
Reply:

Change the SELECT statement to SELECT DISTINCT


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Access Combo Query Filter

MS Access Update Query question www.computing.net/answers/office/ms-access-update-query-question/1463.html

Access help www.computing.net/answers/office/access-help/3588.html

Access 97 Query (no pun intended) www.computing.net/answers/office/access-97-query-no-pun-intended/3942.html