>To get needed appearance you should first modify data into new cursor:
>Select 1 as listorder,recno() as recno,field1 as f1,field2 as f2,field3 as f3, ;
>field4 as f4, field5 as f5 ;
>From table1 ;
>Into cursor tmp ;
>Order by 1,2 ;
>Union All ;
>Select 2 as listorder,recno() as recno,field6 as f1,field7 as f2,field8 as f3, ;
>field9 as f4, field10 as f5 ;
>From table1
>
>Doing this you should provide the same datatypes for corresponding fields. When it's done you can use cursor 'tmp' as grid.recordsource

Edward, thank you so much for your help. This works well except, it shows the first 5 fields for every record then displays the 2nd 5 fields below - so I end up with something like this for a table - let's use 3 records for an example:

f1,f2,f3,f4,f5
f1,f2,f3,f4,f5
f1,f2,f3,f4,f5
f6,f7,f8,f9,f10
f6,f7,f8,f9,f10
f6,f7,f8,f9,f10

Is it possible to have every other row as 1st five fields with the rows in between as the 2nd five fields? Like this:

f1,f2,f3,f4,f5
f6,f7,f8,f9,f10
f1,f2,f3,f4,f5
f6,f7,f8,f9,f10
f1,f2,f3,f4,f5
f6,f7,f8,f9,f10

I'm a firm believer in "Where there's a will, there's a way". :)