latest record query

  • Thread starter Thread starter Guest
  • Start date Start date
The statement looks like this:

SELECT LAST(name of the searched field) AS [e.g. your variable] FROM [your
table];

Of course in MS Access, not in SQL Server....


Barnaby said:
Please help. I need a query that will just select the last record on
Click to expand...
certain subjects
 
How do you know which is the LAST record? Do you have a date time field that
determines this? Or do you have a sequential field that is created? Without
some field with some sort of data to determine the record sequence, there is no
first or last.

It's like having a bag of balls and dropping another ball in the bag. If you
reach in and grab a ball, how do you determine if it is the last. Unless you've
marked the ball with some type of number, you don't know.
 
Back
Top