sort by date

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

I have date in a report grouped by month, only problem is when I order
the month is displays it in alphabetical order instead or the actual
month order. How do I do this? Also I want to order the months
starting from April 2006 proceeding to Feb 2007.

Fiona
 
Assuming you have a date field in your table, create a query that has a
computed field using Format([MyDateField], "yyyymm") and sort on that field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot and Date Problem 2
Excel Help with dates 2
Sorting Month-Year in Query 7
use month in cell date to sum all relevant cells 2
Sorting day names chronologically 5
Sort months by calendar order from a crosstab query 5
Preorder GFX card? 8
Crosstab Date Range Problem 3

Back
Top