Sql

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 DISTINCT ItemID AS Expr1, * from Items where store = "cbochoice"

Quote:

---

Originally Posted by 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

---

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

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.

VB Code:

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