RE: 2 ID's 1 Name

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try this --
SELECT tblMVUP.ChemicalName, First(tblMVUP.ID) AS SelectID
FROM tblMVUP
WHERE (((tblMVUP.Active)=-1))
GROUP BY tblMVUP.ChemicalName
HAVING (((tblMVUP.ChemicalName)<>""))
ORDER BY tblMVUP.ChemicalName;

I used a Yes/No field for tblMVUP.Active.

You would have column 2 as the bound column.



"Brad" wrote:

> Thanks for taking the time to read my question.
>
> I have a product list that has an ID for every product. Each product has a
> name and a size. I have a combo box on one form where size doesn't matter
> (ha ha ha) but I need to limit the combo box list to only 1 of each product.
> I need the ID as a hidden column so that I can stor it in the table.
>
> ID Product Size
> 1 paint 1 Litre
> 2 paint 4 Litre
> 3 brush Small
> 4 brush Large
>
> and so on...
>
> I want my combo box to list:
> paint
> brush
>
> I don't care what ID I store. How can I do this? If I group each ID is
> displayed, If I choose First, I get the First ID, and only one record.
>
> I need one of each product name, and any associated ID.
>
> SQL:
> SELECT tblMVUP.ID, tblMVUP.ChemicalName, tblMVUP.Active
> FROM tblMVUP
> GROUP BY tblMVUP.ID, tblMVUP.ChemicalName, tblMVUP.Active
> HAVING (((tblMVUP.ChemicalName)<>"") AND ((tblMVUP.Active)=True))
> ORDER BY tblMVUP.ChemicalName;
>
>
>
> Thanks,
>
> Brad
.

Relevant Pages

  • 2 IDs 1 Name
    ... I don't care what ID I store. ... SQL: ... FROM tblMVUP ... Brad ...
    (microsoft.public.access.queries)
  • 2 IDs 1 Product Name
    ... I don't care what ID I store. ... SQL: ... FROM tblMVUP ... Brad ...
    (microsoft.public.access.queries)