sign in • sign up
web   discussions   tasks   blogs   photos

Microsoft Access Question. How do you make a report results so in accesending or  email this discussion to a friend?

myLot reputation of 82/100. happyever (534)   ranked 1,069 out of 13,142 in internet 5 years ago

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.

 

internet
sponsors
#1 FLIGHT SIMULATOR 2012
MS Flight Simulator Can't Compete! 120+ Aircraft, More!
www.ProFlightSim.com

Small Business Software
Keeps HR Info in PC-Based Software. No Monthly Fees. Download Demo!
www.abs-usa.com

Salman Rushdie's new book
Rushdie to launch new book in Afghanistan
http://baniannews.blogspot.com

User has not selected a best response.
tags:  computers, microsoft, software
 
1. myLot reputation of 96/100. acmepride (759)   ranked 5,679 out of 13,142 in internet   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
 
2. myLot reputation of 81/100. vikkramm (489)   ranked 3,522 out of 13,142 in internet   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
 
sponsors
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

similar discussions
I Would Like Some Opinions Before I Take The Plunge
Over the years I have seen some beautiful website designs and photography images that really just...
The time reset on my computer...
I'm wondering if anyone knows what this is all about? I noticed yesterday the time on my laptop all...
sponsors
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
return to mylot
We are loading a word from our sponsors. No thanks, cancel loading.