| Microsoft Access Question. How do you make a report results so in accesending or  | | | | Microsoft Access Question. How do you make a report results so in accesending order using a date? the date is in Month,day,4 digit year format. | | | | | | | | | | | | | | | | | | |
| 1. acmepride (759)
|
5 years ago
| | 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. | | | | | | | | | | #1 FLIGHT SIMULATOR 2012 MS Flight Simulator Can't Compete! 120+ Aircraft, More! www.ProFlightSim.com | add comment | | | |
| 2. vikkramm (489)
|
5 years ago
| | 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". | | | | | | | | | | Small Business Software Keeps HR Info in PC-Based Software. No Monthly Fees. Download Demo! www.abs-usa.com | add comment | | | |
| | | Ask Microsoft Support Now 9 Tech Support Reps Are Online! Ask a Question, Get an Answer ASAP. Microsoft.JustAnswer.com
| Fix Microsoft Fix Microsoft in 3 Mins. Download Repair Tool ScanErrors.com/Microsoft
| Laptop Computers Shop for Home, Business or School Laptops. Fully Tested& Guaranteed PicknShipComputers.com/Refurbished
|
| | | | | | | | | Ask Microsoft Support Now 9 Tech Support Reps Are Online! Ask a Question, Get an Answer ASAP. Microsoft.JustAnswer.com | | | Fix Microsoft Fix Microsoft in 3 Mins. Download Repair Tool ScanErrors.com/Microsoft | | | | | |
| |