Access 97 query

I am a power user of MS applications, but a first time user of Access 97. I have developed a small MS Access 97 application. Each time a client visits, a measurement is taken and recorded in the DB along with the date. I want to compare the first measurement with the last measurement. I can think of many hokey ways of doing this (ie a separate table with first and most recent measurements), but would prefer to use a query. I have discovered, though, that Jet returns random records when First and Last are used. I have sorted visits by date, but cannot reliably retrieve the first reading and the last reading.

Thanks

you could try something like this, i know its not the most efficient but it may do the trick.

select top 1 * from table_name order by date_column

select top 1 * from table_name order by date_column desc

that should do it

Didn't really work. I think I'll need to add a counter (not the ID) that will tell me the order of the visits then sort n select on that. Thanks for the help!