Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - select the top 5 data
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

select the top 5 data
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
brolinuk View Drop Down
Newbie
Newbie
Avatar

Joined: 24 October 2003
Location: United Kingdom
Status: Offline
Points: 24 		Post Options Post Options   Thanks (0) Thanks(0)   Quote brolinuk Quote  Post ReplyReply Direct Link To This Post Topic: select the top 5 data
    Posted: 30 October 2003 at 12:12am
Anyboy could tell me how would I be able to select the top 5 data in a certain order from the Access database. For example, I want to display the five most recent data in a time sequence.
Back to Top
zaboss View Drop Down
Senior Member
Senior Member


Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zaboss Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2003 at 12:24am
Select Top 5 * from YourTable Where YourSQLQuery Order By Date DESC
Cristian Banu
Soft 4 web
Back to Top
brolinuk View Drop Down
Newbie
Newbie
Avatar

Joined: 24 October 2003
Location: United Kingdom
Status: Offline
Points: 24 		Post Options Post Options   Thanks (0) Thanks(0)   Quote brolinuk Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2003 at 1:25am

Thanks zaboss

How about list by random order

Back to Top
zaboss View Drop Down
Senior Member
Senior Member


Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zaboss Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2003 at 1:48am

I guess you can build a function in which to play with the date and re-order them randomly (a way of speaking as it still would be something logicaly ordered)...

My advice is to let it this way unless realy necesary.
Cristian Banu
Soft 4 web
Back to Top
gupta_ji View Drop Down
Groupie
Groupie
Avatar

Joined: 29 October 2003
Location: India
Status: Offline
Points: 70 		Post Options Post Options   Thanks (0) Thanks(0)   Quote gupta_ji Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2003 at 6:54am
i have same question
chartered accountants India, accounting Outsourcing ISO Certification
Back to Top
Badaboem View Drop Down
Senior Member
Senior Member


Joined: 12 April 2002
Location: Netherlands
Status: Offline
Points: 600 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Badaboem Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2003 at 7:05am
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?ln gWId=4&txtCodeId=6201
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.