Need a Select query that strips duplicates

[mych]

I have a table that contains the following
[tt]
TblRequirements

RefNo TeamNo ReqNo ProjID
(Auto) (Number) (Number) (Text)
1 1 5 MD123
2 1 6 MD123
3 2 9 MD987
4 3 12 MD123
5 3 14 MD123
6 6 19 MD123
[/tt]

What I need is a Select query I can use to populate a cbobox which will list the TeamNo for a particular project.

My efforts to date give me the TeamNo but will include duplicates. For example for projectId MD123 I get 1,1,3,3,6 and all I want is 1,3,6

Any help appreciated!

 

[SkipVought]

Hi,

[tt]
Select Distinct...
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[mych]

Thanks Skip,

Works a treat!

Mych