Sql

[pame1la]

Select * from Items where store = "cbochoice"

how do i change the above query so that it returns all columns from items table BUT does not repeat a ItemID more than once.... the primary key in this table is the temID AND the Itemsize

[mik706]

SELECT DISTINCT ItemID AS Expr1, * from Items where store = "cbochoice"

[moinkhan]

Select * from Items where store = "cbochoice"

how do i change the above query so that it returns all columns from items table BUT does not repeat a ItemID more than once.... the primary key in this table is the temID AND the Itemsize

select max(itemid) from items where store ="cbochoice"
group by itemid

[Hack]

Which ever of the above choices works best for you, you probably want to slightly amend your statment to include single quotes around your combo box entry.

...FROM Items WHERE store = '" & cbochoice & "'"