Software

Ask something
Discussion Locked

MIXED RECORDS IN A MSACCESS TABLE !

0 helpful
1 reply

by dolj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by eschlangen

Add an integer field to the input table. Put numbers in this field to indicate the order that you want the records to be ordered by. Create a make table query that includes this field with an ascending sort (you can include this field in the new table or not, as you wish). Run this query and you will have a new table identical to the first except that it is ordered as you want.

This discussion is closed to new replies.