Query order <> Report Order

  • Thread starter Thread starter AlexHWGUY
  • Start date Start date
A

AlexHWGUY

Hi

I use this query in my Report :
SELECT calendrier.dateDebut, calendrier.dateFin,
calendrier.evenement, calendrier.lieu,
calendrier.dateAffichage, calendrier.organisation,
calendrier.responsable, calendrier.courriel,
calendrier.addrInternet, calendrier.telephone,
calendrier.telecopieur, calendrier.affichageInternet,
calendrier.dateEntre
FROM calendrier
ORDER BY calendrier.dateDebut, calendrier.dateFin,
calendrier.evenement;

The query alone work fine but in my Report, order is not
exactly the same :

In Query :
dateDebut dateFin evenement
2004-05-05 2004-05-07 2nd Traffic...
2004-05-05 2004-05-07 ECOMM 2004...

In my Report that use the query from above:
ECOMM 2004...
2nd Traffic...

??????
 
I will answer to myself :
Query order does'nt show in Report because we must use
the "Sorting and Grouping" option in report ...

Thanks to myself !!
 
Back
Top