Hi folks local nut case loose with access again and brain full of ideas, anyways
Have this append query which works just dandy
INSERT INTO PlayerOneTable ( PlayerOneLetters )
SELECT TOP 7 ScrabbleLettersToUse.Letter
FROM ScrabbleLettersToUse
WHERE (((ScrabbleLettersToUse.LetterUsed)=False))...