"RTL" <NOMORESPAM@here.com> wrote in message
news:0UJLf.24883$Zl1.13410@twister.nyroc.rr.com...
>I can't seem to find that command in the SQL 2000 reference. By chance,
> would any gurus know it? I have a query that is producing very bad reports
> (off by 30K) with a query that _should be_ functionally equivalent; but is
> not it seems. The only inherent difference is the Access SQL call uses
> Last(x) function and SQL query does not.
>
> Thanks in advance and enjoy your weekends,
>
> Rich
>
>

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:OvN68XZOGHA.2740@TK2MSFTNGP12.phx.gbl...
> Realistically, Last isn't a particular reliable function, since it depends
> on the order of the records, and you can never assume anything about the
> order of the records in a table. That means you must use a query with an
> ORDER BY clause in order to be sure of the order. If your ORDER BY is
> sorting in ascending order, reverse it to sort by descending order, and
> use TOP 1 to get the last row.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "RTL" <NOMORESPAM@here.com> wrote in message
> news:0UJLf.24883$Zl1.13410@twister.nyroc.rr.com...
>>I can't seem to find that command in the SQL 2000 reference. By chance,
>> would any gurus know it? I have a query that is producing very bad
>> reports
>> (off by 30K) with a query that _should be_ functionally equivalent; but
>> is
>> not it seems. The only inherent difference is the Access SQL call uses
>> Last(x) function and SQL query does not.
>>
>> Thanks in advance and enjoy your weekends,
>>
>> Rich
>>
>>
>
>

"Mano Bains" <Cooly81@blueyonder.co.uk> wrote in message
news:mAnMf.62744$DM.29536@fe3.news.blueyonder.co.uk...
> Use;
>
> "Select MAX(x)
> from dbo.y"
>
> where x is the unique identifier and y is the table name.
>
>
> Regards,
>
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
> news:OvN68XZOGHA.2740@TK2MSFTNGP12.phx.gbl...
> > Realistically, Last isn't a particular reliable function, since it
depends
> > on the order of the records, and you can never assume anything about the
> > order of the records in a table. That means you must use a query with an
> > ORDER BY clause in order to be sure of the order. If your ORDER BY is
> > sorting in ascending order, reverse it to sort by descending order, and
> > use TOP 1 to get the last row.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "RTL" <NOMORESPAM@here.com> wrote in message
> > news:0UJLf.24883$Zl1.13410@twister.nyroc.rr.com...
> >>I can't seem to find that command in the SQL 2000 reference. By chance,
> >> would any gurus know it? I have a query that is producing very bad
> >> reports
> >> (off by 30K) with a query that _should be_ functionally equivalent; but
> >> is
> >> not it seems. The only inherent difference is the Access SQL call uses
> >> Last(x) function and SQL query does not.
> >>
> >> Thanks in advance and enjoy your weekends,
> >>
> >> Rich
> >>
> >>
> >
> >
>
>