Mstrmage1768, won't that give her what she's already getting--dates sorted alphabetically by month?
Imagranny,
It sounds to me like your query already has a Format() expression as one of its columns, and you're sorting on that. That's a mistake--you shouldn't format a date until the point where it's displayed, that is, on the form or report. If you've done it in the query because you open the query for direct viewing in other circumstances, then make a separate query without Format() for the report. Do your date formatting in the report's control.
Or did I guess wrong about your query? Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein