Is there any way to retive the last 4 records hich have been entered to a data base. I have been thinking of ways to do it but just come up blank....
Do you have an IDENTITY or AUTONUMBER field in your record layout? If so, you can do a SELECT query using TOP 4. If not, do you have a date/timestamp? If so, you can still use the TOP 4. If not, you are pretty much out of luck.
I do have an autonumber field but how do I then get the top four records back?
SELECT TOP 4 * FROM mytable ORDER BY autonumberfield DESC.