By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,486 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Pulling the Record Number into a Query

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.