469,602 Members | 1,998 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Pulling the Record Number into a Query

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
Nov 12 '05 #1
1 1486
Thanks for the advice Guys.....

You should see my ammended post above.

<snip>
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Skully Matjas | last post: by
12 posts views Thread by magmike | last post: by
reply views Thread by emalcolm_FLA | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.