SORT PROBLEM

Posted by YANECKC on March 16, 2001 9:55 AM

I HAVE A REPORT WITH 5 COLUMNS.HOWEVER THERE IS DATA
ON THE NEXT ROWS THAT MUST STAY TOGETHER AFTER A SORT.
SEE EXAMPLE BELOW

CODE/ID DESCRIPTIONS ACCOUNT DATE QUANTITY
A111111 AIR PRODUCTS 210-22 0205 2
09090 INC LA

B221234 BOUNTY OF 310-45 0301 5
CONNECT AND
BOSTON

N567654 NEW YORK INC 567-23 0203 111
09000 OF TENNIS

C345432 COMPUTER PAT 234-45 0101 50
01000 INC LA

===============================================
THE PROBLEM IS I AM TRYING TO SORT BY ID. NOT ALL
PRODUCTS HAVE ID. THAT OK BECAUSE THEY WILL APPEAR
AT END OR BEGINNING DEPENDING ON SORT. BUT SOMETIMES
THE PRODUCTS ARE IN TWO ROWS OR THREE ROWS OR EVEN
FOUR ROWS. SO AFTER THE SORT I NEED THOSE ROWS INTACT.

THANKS YANECKC

Posted by Slich on March 16, 2001 11:25 AM

Insert new column like "RecID" to right of your "code/id". Each row of a specific product should get same (unique) "RecID". Then use this new column as the primary sort, "Code/ID" secondary. You would of course be best off making sure that each single product record be in a single row and just add add'l columns instead of rows for the same record. Good Luck