This must be simple but i am struggling. I have 2 tables that are joined by a style-code. In the first table there is only a single occurance of the style-code, in the 2nd table there can be up to 10 occurances of the style-code and the same reference 10 times. I need to retrieve the reference from the 2nd table, but only want it once. I have tried group but get a syntax error.

In summary how do i design my query joinging th2 tables but only get 1 matching record from the 2nd table?

Thanks

Go into sql view and add Distinct

Select Distinct ...


Lookup unique in access help

Brian

Scarily Simple, thanks very much