Combobox

[Beany]

Hi,

a simple one...........

i have a combobox with a list of line providers....... (from table tab_data).....

BT is one of the providers...........

In the list it shows BT several times, how can i limit this to one? i dont want replica data in the list............

[nico5038]

The problem of this lies in the data in your table, let's assume the table look like:
1 BT
2 XYZ
3 BT
Then BT will appear 2 times. I would have define a unique index on the company name, to prevent that users enter the same company twice. When you have this in your table you have two options:
1 Qualify the names to make them unique like:
1 BT World Wide
2 XYZ
3 BT US
2 Use a GroupBy query, but then you need to decide which code to use like:
select Max(code), company from tab_X group by company
that gives for yor combo:
2 XYZ
3 BT
Or
select Min(code), company from tab_X group by company
Giving:
1 BT
2 XYZ
It's not possible to have two values for one field in a GroupBy....

Nic;o)

[NeoPa]

In a QueryDef, if you look at the properties of the QueryDef itself, you will see Unique Values and Unique Records. These can also be used to remove duplicates from a simple SELECT type query.

[Killer42]

In a QueryDef, if you look at the properties of the QueryDef itself, you will see Unique Values and Unique Records. These can also be used to remove duplicates from a simple SELECT type query.

But how do you put them in an SQL string?

[hariharanmca]

Hi,

a simple one...........

i have a combobox with a list of line providers....... (from table tab_data).....

BT is one of the providers...........

In the list it shows BT several times, how can i limit this to one? i dont want replica data in the list............

then use the distinct QRY Like

========================QRY======================


strSql="Select distinct FieldName from TableName"

[NeoPa]

then use the distinct QRY Like

========================QRY======================


strSql="Select distinct FieldName from TableName"

That's right - You can use the DISTINCT and DISTINCTROW predicates within the SELECT clause.