first and last record that meet a specific criteria

[Stefan Goerres]

Hello!

I have a table which hold position data. There are some columns with the
actual position data itself and additionally there is a column for time and
date and a column that holds a number for the position that are going
together. So what I need is a query showing my there first and last position
for each move.
Any idea how to do this?

Thanks a lot
Stefan

 

[Michel Walsh]

Hi,


have you take a look at http://www.mvps.org/access/queries/qry0020.htm ?


Hoping it may help,
Vanderghast, Access MVP