how to sort datas on a field

[231166]

Hi,

I have a table called 'relance' and i have several fields inside : reprop, relibelle, redate, redebit.
I can see the field reprop is sorted but the field redate is not sorted and i need to see it sorted also .
I have created a group by on the field reprop but i can see only one record with each 'reprop ' after what is not correct.
could younhelp me to create a sql request to have the datas sorted as i need.
Here is how it is in the table

reprop relibelle redate redebit

001 appel1 01/01/2001 256 euros
001 appel2 01/01/1999 300 euros

001 appel6 01/01/2005 400 euros
002 appel2 01/01/2001 566 euros
002 appel2 01/01/1998 569 euros

You can see the field 'redate ' si not sorted an di need to see it sorted.
Can you help me for this.
Thanks a lot for your help.

Nahalie

 

[JerryKlmns]

In SQL View of a query paste this

SELECT reprop, relibelle, redate, redebit
FROM relance
ORDER BY reprop, redate;


The take a look on ORDER BY at the help files.