hi
i am trying to create a recordset containing the last 5 records inserted in the db.
I can filter with the ID descending but how do i limit it to 5 records?
thanks
Dave

Try:

SELECT TOP 5 FROM TableName
ORDER BY RecordID DESC

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

OMG, Is it really as easy as that?
How dumb am I? (rhetorical)
Thanks
Dave


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Try:

SELECT TOP 5 FROM TableName
ORDER BY RecordID DESC

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

tried it and it don't work

"the SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is wrong"

thanks anyway

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Try:

SELECT TOP 5 FROM TableName
ORDER BY RecordID DESC

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

You could use the 'Repeat Region' server behavior that is default with UD, and just select 5 results.

(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com

Yes thanks
I have done that but didn't like it. I would prefer to have just one record at a time and have the user navigate through the records.
Dave

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
You could use the 'Repeat Region' server behavior that is default with UD, and just select 5 results.

(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi Dave,

Try the following syntax and remember to put a space between your number and the *


SELECT TOP 5 * FROM TableName
ORDER BY RecordID DESC

Regards,

Jean-Marie

Oops! <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Thanks Jean-Marie.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

You're welcome Owen. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> I learned that from you, you know??? lol

Regards,

Jean-Marie

thanks guys

not tried the * in it yet but will do.

Dave