Cheers for the reply just got it kind of working by putting in brackets

SELECT tblResults.FinishPosition,tblRaceEnterants.RaceNumber,tblResults.FinishTime, tblResults.Age FROM ((tblResults

INNER JOIN tblRaceEnterants ON tblResults.RaceID = tblRaceEnterants.RaceID) INNER JOIN tblCompeditors ON tblResults.CompID...

cheer for the reply my spelling might have been a bit rubish as i was a bit dopped up on pain killer after an op and i posted the question...

hi all again still not quite right, I think all need to be able to do in the tied table is to get the all the distinct userid tied...

cheers i'll give it a go tomorrow

there are only four columns to find the information to return, but there will be quite a few userid more than 2 but...