** Remove the simple_ to reply to me directly **

Here's a challenge for you wizards out there...

I would like to reflect the 2nd record from a query on my
asp page. I know how to get the 1st record only (show 1
record only) but doe anyone know how/if i can show only
the 2nd record?

Every question (which is few) that I have posted here has
always been answered so my thanks go to ALL that input
here. If you have an DRW question, you have to check out
www.outfront.net a site i was referred to recently, it is
awesome!

Many thanks

Simon

Try using Top 2, and Order By <fieldname> Desc "

"Select Top 2 from table Order by fieldname Desc"

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Simon Ransom" <(E-Mail Removed)> wrote in message
news:014701c3660d$5dfb1590$(E-Mail Removed)...
> ** Remove the simple_ to reply to me directly **
>
> Here's a challenge for you wizards out there...
>
> I would like to reflect the 2nd record from a query on my
> asp page. I know how to get the 1st record only (show 1
> record only) but doe anyone know how/if i can show only
> the 2nd record?
>
> Every question (which is few) that I have posted here has
> always been answered so my thanks go to ALL that input
> here. If you have an DRW question, you have to check out
> www.outfront.net a site i was referred to recently, it is
> awesome!
>
> Many thanks
>
> Simon

Actually, now that I think about it, you could use a subquery:

SELECT TOP 1 (*) FROM
(SELECT TOP 2 (*) FROM MyTable ORDER BY SomeField)
ORDER BY SomeField DESC

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.

"Simon Ransom" <(E-Mail Removed)> wrote in message
news:073c01c36610$f9759b50$(E-Mail Removed)...
> But thanks Thomas because i think you have put me on the
> right track...if i use a seperate query in Access i
> should be able to do what you suggest. I will try it
> when i get home tonight.
>
> I am able to do things outside of the DRW (just not
> expert) so if you have an sample of code please let me
> know.
>
> Regards
>
> Simon
>
> >-----Original Message-----
> >Sorry, I see you are using the DB Wizard, which I don't
> use, so I am not
> >sure how you would implement my example.
> >
> >--
> >
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, Forums, WebCircle,
> >MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage
> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> >"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> >news:(E-Mail Removed)...
> >> Try using Top 2, and Order By <fieldname> Desc "
> >>
> >> "Select Top 2 from table Order by fieldname Desc"
> >>
> >> --
> >>
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> WEBMASTER Resources(tm)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, Forums, WebCircle,
> >> MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for
> FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Simon Ransom" <(E-Mail Removed)> wrote in
> message
> >> news:014701c3660d$5dfb1590$(E-Mail Removed)...
> >> > ** Remove the simple_ to reply to me directly **
> >> >
> >> > Here's a challenge for you wizards out there...
> >> >
> >> > I would like to reflect the 2nd record from a query
> on my
> >> > asp page. I know how to get the 1st record only
> (show 1
> >> > record only) but doe anyone know how/if i can show
> only
> >> > the 2nd record?
> >> >
> >> > Every question (which is few) that I have posted
> here has
> >> > always been answered so my thanks go to ALL that
> input
> >> > here. If you have an DRW question, you have to
> check out
> >> > www.outfront.net a site i was referred to recently,
> it is
> >> > awesome!
> >> >
> >> > Many thanks
> >> >
> >> > Simon
> >>
> >>
> >
> >
> >.
> >