If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unique list for multiple comboboxes.
Hi, i have a form with a combobox. This combobox displays a list of records
to be selected for a query. How can I make it to display only unique records?? *using ACC2003 ** I have tried setting 'Yes' the Unique property in a query , but did not work. thank you. |
#2
|
|||
|
|||
Unique list for multiple comboboxes.
Post the SQL of the query.
When you set Unique to Yes, it adds DISTINCT to the SQL statement. My guess is that you have multiple columns here, and the combination of them all is distinct, even though the bound column values are not distinct. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Juju" wrote in message ... Hi, i have a form with a combobox. This combobox displays a list of records to be selected for a query. How can I make it to display only unique records?? *using ACC2003 ** I have tried setting 'Yes' the Unique property in a query , but did not work. thank you. |
Thread Tools | |
Display Modes | |
|
|