Re: maxrecords property doesn't work for me

Bob Barrows [MVP] wrote:
strSQL = "SELECT TOP 5 q.ScoreDate, q.CurrentDifferential " & _
"FROM (" & _
"(SELECT TOP 10 ScoreDate, CurrentDifferential FROM Score " & _
"WHERE PlayerName = '" & strPlayersName & _
"' ORDER BY ScoreDate DESC) As q " & _
"ORDER BY q.ScoreDate ASC"


Of course, I don't have access to your database so I can't test this,
but it looks like it should work, if I haven't missed any typos.

Oops, well I did miss a typo: there are two opening parens after the
first FROM. There should only be one.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: ? re. Legal Apps? & ODBC?
    ... based connections (SQL Server & Sybase SQL Anywhere) ... Universal Data Access & Virtual Database Technology Providers ... > All responses should be made to this newsgroup within the same thread. ... >> MVP Entourage ...
    (microsoft.public.mac.office.entourage)
  • Re: How To Return Record Number From AddNew
    ... MSFT bloatware, silly help windows popping up all over the place, and ... ADOX to create the database ... ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: maxrecords property doesnt work for me
    ... It isn't the same as the five lowest scores ... "ORDER BY q.CurrentDifferential ASC) As q1" ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: number comparison
    ... dateAccrueVation has priority 1 if compared to ... database, then depending on which database, you can probably achieve ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: Multihomed DNS Server Mailserver Webserver Fileserver
    ... Kevin D. Goodknecht posted their thoughts, ... Newsgroup Etiquette: ... Please direct all replies to the newsgroup so all can benefit. ... Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP ...
    (microsoft.public.win2000.dns)