Alpha sort inside a numeric sort

[choco]

I am doing an expiry date sort - this part works out just fine - the list is sorted into dates.  How do I get the list into alphabetical order inside the dates sort?

 

[Guest_imported]

Is this a query or a report? <br>A Query, by sort select ascending under the field you want alphabitized. <br>A report, add the field to the sorting and grouping.

 

[elizabeth]

just curious what is &quot;expiry&quot;?

 

[choco]

glo4 - Yes, I can get it to work the way you say but only for ONE field.&nbsp;&nbsp;It will not let me sort (alphabetically) within another sort (numeric date).<br>

 

[Guest_imported]

I do this sort of thing all the time in Access as well as Crystal Reports. Make sure the Expiry date is the leftmost field in your QBE grid and that the field you are trying to alphabitize is just to the right of Expiry date. make sure both fields say ascending in them then look at the data. <br>expiry date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name<br>1/1/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;susie<br>1/1/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;tom<br>1/2/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;andy<br>1/2/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sally<br>is the look you will get<br>it sorts by date then name<br>if you want to see<br>expiry date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name<br>1/1/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;andy<br>1/1/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sally<br>1/2/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suzie<br>1/2/00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tom<br>it aint goin happen without 2 seperate queries<br>good luck hope this is what you had in mind

 

[choco]

THANK YOU, THANK YOU, THANK YOU.&nbsp;&nbsp;YOU ARE A GENIOUS!!!!<br>Who would have thought that the order they are listed in the db would do it (not me)<br><br>GLO4 IS A GENIOUS<br>