SImple SQl statement help!

[GoAutoWay]

I need CIR.vendor to be distinct. here is the code that does not use distinct. I can't just stick dinstinct row or distinct in there because there is a different index number for each row. This is for a listbox on a form.


SELECT CIR.Vendor, CIR.index
from CIR
ORDER BY CIR.Vendor;

 

[dhookom]

Why do you need index? Can you provide some sample records and what you expect to see in the results?

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya GoAutoWay . . .

I get the impression that [blue]CIR[/blue] is a child table with multiple CIR having the same [blue]index[/blue]. Whats preventing you from using a query with a [blue]Group By[/blue] clause?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]