Queries filter

[glen]

Hi friends,
suppose we have a combo for a field named Location.
now we have too many same names in location.


I want to show just one time every name in combo.
so what will be criteria?
Thanks

[orange]

Use a DISTINCT in your Select statement (rowsource of the combo)

Watch this free video tutorial http://www.datapigtechnologies.com/f...combobox1.html

[glen]

Thanks for you help.
But I forgot to mention that every Location have also a unique id.
1 XYZ
2 XYZ
3 ABC
4 ABC
which is not working in this method.

[orange]

So what exactly do you want? Unique values for the ABC, XYZ - then select Distinct whateverThatFldIsCalled from your Table.