General discussion
July 23, 2004 at 01:51 AM
dolj

MIXED RECORDS IN A MSACCESS TABLE !

by dolj . Updated 22 years, 2 months ago

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

This discussion is locked

All Comments