Drop down Combo box

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
Hi,


SELECT DISTINCT fieldNameHere FROM tableNameHere


as rowsource for the combo box should do the job.




Hoping it may help,
Vanderghast, Access MVP
 
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
 
Back
Top