murray83
Games Collector
- Local time
- Today, 01:06
- Joined
- Mar 31, 2017
- Messages
- 787
Hi folks local nut case loose with access again and brain full of ideas, anyways
Have this append query which works just dandy
and looks like so
i how ever would like it to append across wise so it would all be on one record, so my question is how
have tried google and even ai but nothing helps
cheers all
Have this append query which works just dandy
Code:
INSERT INTO PlayerOneTable ( PlayerOneLetters )
SELECT TOP 7 ScrabbleLettersToUse.Letter
FROM ScrabbleLettersToUse
WHERE (((ScrabbleLettersToUse.LetterUsed)=False))
ORDER BY Rnd([ID]);
and looks like so
i how ever would like it to append across wise so it would all be on one record, so my question is how
have tried google and even ai but nothing helps
cheers all