My SQL SERVER has rows like so:
Reply 1
Reply 2
Reply 3
Reply 4
Reply 5
Reply 6
Reply 7
What I'm trying to do is show the last 5 replies so it would so it would show the replies like:
Reply 3
Reply 4
Reply 5
Reply 6
Reply 7
I'm currently using:
qryr = "SELECT TOP 5 * FROM " & sql_table & " WHERE Resto='" & show.Fields("PostNo") & "' ORDER BY PostNo ASC"
However, it shows the replies like:
What I'm trying to do is show the last 5 replies so it would so it would show the replies like:
Reply 7
Reply 6
Reply 5
Reply 4
Reply 3
Basically, I'm looking for something that is the opposite of SELECT TOP. I've Googled the hell out of this, and I got a few answers that didn't work.
Thank you.