>I am trying to get an application to print off a chronological list of units, well the problem is that I have one unit and I need to display five tasks for that unit before I go to the next unit I know a set order command would work in a way but is there a command I can use in the report (at run time) that will do this for me?
Firstly you get cursor (ordered as you want), and then print from this cursor.
Select * from table1 into cursor tmp order by 4,5
Report form ...
Edward Pikman
Independent Consultant