Microsoft Access Question. How do you make a report results so in accesending or
By happyever
@happyever (581)
India
2 responses
@vikkramm (497)
• India
31 May 07
First make sure your date is qualified in MS Access. Buy him/her an expensive dinner, and whip out your laptop and get him/her to... oh, THAT kind of date.
I'm using Access 2007 so it might look a bit different, but go to the design view for the report and look for a property on the report itself called "Order By". Just fill that in with the name of the column you want to sort on, and make sure "Order By On Load" is set to "Yes".
You can get fancy in the Order By property and do things like ASC/DESC, or use commas to specify sort priorities.
So... if you had one Date/Time column called "Timestamp", you could order by "Timestamp ASC" or "Timestamp DESC" depending on which way you want it to run.
If your date is actually broken out into separate columns, you could order by "Year, Month, Day", or "Year DESC, Month DESC, Day DESC".
@acmepride (1546)
• United States
31 May 07
I'm not really too knowledgeable as regards Microsoft Access, happyever.
However, I came across a website, which could perhaps help you out.
If possible, check this out: http://www.bcschools.net/staff/AccessHelp.htm
I hope it could be of help.


