Hey David!

I had posted my problem about the profit loss program, which I think will be included in this post. Thank you so much for your help!! However, I am running into a problem which I have been trying to work out. When I do the PADR, I seem to be not bringing over the description in conjuction with the groupcode. The description remains the same for all the groupcodes. So let me show you what I have, and I will also show you what I am doing with the drag and drop records. Maybe you could shed some light on my procedure:

TABLES USED:

Report1 (print_order N(3), desc C(50), groupcode N(3), gl_code N(3), total N(12,2), I_L C(1)
Reportnames (names C(50), groupcode N(3)

WHAT CURRENT GRID LOOKS LIKE: (Right-click method on Print_Order)

PRINT_ORDER DESCRIPTION GL_CODE TOTAL
1 DVD Income 410 50,000
2 DVD Loss 510 10,000
3 GROSS DVD Income X 40,000
4 VHS Income 420 50,000
5 VHS Loss 520 60,000
6 GROSS VHS Income X -10,000

______________________________________________________


I created the table that would hold a groupcode description and did your suggested PADR:

SELECT PADR(Reportnames.Name + " TOTAL",25) AS Desc, ;
" " AS Gl_code, ;
IIF(I_L = "I",Total,Total*-1) AS Total, ;
Groupcode, ;
"X" AS I_L ;
FROM Report1 ;
GROUP BY Groupcode ;
ORDER BY I_L ;
INTO CURSOR SummaryTable

RESULTS: (NOT WHAT I EXPECTED - AS YOU CAN SEE THE DESCRIPTION REMAINS THE SAME, AND THE GROUPCODE HAS DIFFERENT VALUES AS NEEDED.)

DESCRIPTION CODE AMOUNT groupcode I_L

DVD TOTAL 40000 10 X
DVD TOTAL -10000 20 X

THEN:

SELECT Desc, Gl_Code, Total, GroupCode, I_L ;
FROM Report1;
UNION SELECT Desc, Gl_Code, Total, GroupCode, I_L ;
FROM SummaryTable ;
ORDER BY Groupcode, I_X ;
INTO CURSOR DisplayTable

BLOWS AN ERROR: SQL-ORDER BY clause is invaild

So I do not know if you can shed any light on something that I may be doing wrong. I do want to share that I have an idea as to how to move these records, but I am running into the problem of getting the system to reorder correctly:

Right click on the print_order of the one you want to move. The system changes the print_order number of that record to -1. A form asks you what is the new number you wish it to be (say 5). I have a seek for the actual record that says 5. I think if I were to change it to a 6 instead of a 0 and then increment all print_order < 6 with a + 1 that it may work. I just keep on gaining a number. I gave up the drag and drop because all it did was completely replace the number opposed to reordering and renumbering.

Thank you once again for all your help, and I do hope that you will be able to assist me with this.