HELLO !
WHO CAN HELP ME , PLEASE ?
HOW CAN I GET FROM AN INPUT MSACCESS 2000 TABLE
AN OUTPUT TABLE HAVING THE SAME NUMBERS OF RECORDS, BUT ARRANGED IN A DIFFERENT ORDER .
FOR EXAMPLE RECORD #1 IN THE FIRST TABLE BECOMES
RECORD #7 IN THE SECOND TABLE ,THE RECORD #2 IN THE INPUT TABLE BECOMES #23 IN THE SECOND TABLE ,
THE RECORD #3 IN THE FIRST ONE BECOMES RECORD #4
IN THE SECOND TABLE , AND SO ON….
IT’S A RANDOM ORDER IN THE SECOND TABLE .
I WOULD LIKE TO SOLVE THIS PROBLEM USING AN APPEND
QUERRY …
WHO CAN TELL ME HOW ???
THANK YOU VERY MUCH !
REGARDS,
EMIL