sort fields in queries

[abu taher]

I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like
name | address | date this 3 fields in table1
Roll | Class | date this 3 fields in table2
name | date | roll | date this 4 fields in querie1
now this data show in querie1 like
Taher | 17/11/2008 | 100 | 16/11/2008
but I want it show in two row with sort by date like:
Taher | 17/11/2008
100 | 16/11/2008
how can I do this

[kb.net]

Hi,
Your example is not that clear but i guess that you need to transfer your query to a crosstab.