Pulling the Record Number into a Query

[John Ortt]

I have a table of dates in ascending order but with varying intervals. I
would like to create a query to pull out the date (in field 1) and then pull
the date from the subsequent record (and store it in field 2).

I would like to run a query that returns all the data in the table plus the
record number, in a similar sense to the getuser() command to get the User's
Identity, I would like a GetRecord() command.

Is this possible, or can someone think of a better way of doing this?
Thanks, John

Crossposted to:
------------------
microsoft.public.access
comp.databases.ms-access
baesystems.comp.office-software

[John Ortt]

Thanks for the advice Guys.....

You should see my ammended post above.

<snip>