Drop down Combo box

[Adam]

Hi,

I use a drop-down Combo box on a form. The list of
variables consists of numbers from a table.

Sometimes those variables are unique. Sometimes not.

How do I 'Filter' or 'Group By' these variables so that
only one variable of the one value is returned rather than
multiple variables of the same value?

Ie instead of: 1,1,1,3,4,4,4,4,5,6,6,6...

I want 1,3,4,5,6... to show.

Thanks for you help

Adam

 

[Michel Walsh]

Hi,


SELECT DISTINCT fieldNameHere FROM tableNameHere


as rowsource for the combo box should do the job.




Hoping it may help,
Vanderghast, Access MVP

 

[Adam]

Hi,

I had -

SELECT [Set Date].[AreaCode] FROM [Qry Set Date]

Now it's

SELECT Distinct [Set Date].[AreaCode] FROM [Qry Set Date]

Beautiful. Thanks heaps.

aj