latest record query

B

Barnaby

Please help. I need a query that will just select the last record on certain subjects
 
M

Maciek Paras

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
 
J

John Spencer (MVP)

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.
 
Top