Combo Box and Query

[Guest]

Hi,

I am creating a combo box to pass parameters for a query. A column,
"Category" in a table will be used for selection of the parameters. However,
each category has multiple rows. Are there any ways to make each category
name only appear once in the combo box?

Thanks,

 

[Ken Snell [MVP]]

Use a slightly different query:

SELECT DISTINCT TableName.Category
FROM TableName;

 

[Guest]

Sounds a good idea. Thank you...

Use a slightly different query:

SELECT DISTINCT TableName.Category
FROM TableName;