From: Malcolm@indaal.demon.co.uk   
      
   When creating a report to print out some data, one can control the order   
   in which the records are sorted. My problem is that I don't want them   
   sorted at all, I want them to appear in exactly the same order as in the   
   underlying table, and they won't!   
      
   My data consist of records copied from old file cards. Each card is   
   identified by a unique name and contains a varying number of records   
   with four fields, the first of which can be blank.   
      
   The data have been entered in a table thus:   
   Field 1           Fd 2, Fd 3, Fd 4, Fd 5   
   Card name   data, data, data, data   
   Card name   data, data, data, data   
      
   Records per card can vary from 1 to c.40   
      
   The unique name is used as a group band on the report and I want to   
   print out the records on each card in identical order so that they can   
   be checked for data entry errors.   
      
   Group name (Field 1 from table)   
   Record 1:  Field 2, Field 3, Field 4, Field 5   
   Record 2:  Field 2, Field 3, Field 4, Field 5   
   etc.   
      
   I haven't selected any field on which to sort the data in the All   
   records band. However, the records appear in the report sorted on Field   
   3, which always has data in, and then on Field 2, which may or may not   
   have data. All records in which Field 2 are blank appear first in   
   alphabetical order of Field 3, followed by all records in which there is   
   an entry in Field 2, again in alphabetical order of Field 3.   
      
   I tried changing the field order in the Table, putting Field 3 before   
   Field 2, which merely resulted in the records appearing in the report   
   sorted on Field 3, ignoring Field 2.   
      
   Can anyone show me how to stop the records being sorted in the report,   
   please?   
      
   --   
   Malcolm   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)