Combo Box and Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
Use a slightly different query:

SELECT DISTINCT TableName.Category
FROM TableName;
 
Back
Top