I have a database named site.mdb and I would like to get the last 8 entries from a table called SITE_MEMBERS and write it into an html table. The primary key is an autonumber and the values I would like to write to the new html table are M_MEMBER and M_DATE. Could anyone help me out with this?
(FYI, it would also help me out with 3 other problems I am currently facing)
Thanks All!
PS, anyone know if reply notification will be put back on the these forums?
SELECT TOP 8 M_MEMBER, M_DATE from SITE_MEMBERS Order by MEMBER_ID DESC
This will return you a recordset with the last eight entries from the table (assuming your autonumber field is called MEMBER_ID). You can then loop around the recordset to display those fields as you like.
Topic Locked
Posted - 11 August 2001 : 16:00:54
