Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sorting report by dates

Status
Not open for further replies.

nmsnps

Programmer
Sep 26, 2005
1
US
I have a report of students who graduate by quarter and year (for example,
03/05, 06/05, 09/05, 12/05, 03/06, 06/06, 09/06, 12/06, etc.) It currently
is sorting by month (for example, 03/05/, 03/06, etc.) I need it to sort by
month and year (03/05, 06/05, 09/05, 12/05, 03/06, 06/06, 09/06, 12/06 etc.)
I read the access help file on dates and it sorts by month. Is there any way
to get it to sort the way the end user wants it by month and year. I have
tried text, number and date data types to no avail. Using Access 2003.
 
What is your field name and type that you want to sort by? Are you actually storing just a text value like "03/05" or is this a date field formatted to display on the month and year.

If you need to separate the year from the month in a text field, you can use string functions like Mid(), Left(), Right(), Instr()...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top