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

reading next record in a query

P: n/a
I have a database that keeps track of hockey games which I work at. In one
table, I have the season's schedule. I want to put together a query that
has the complete schedule, but also I want each record to show when the next
game is (for example, on game 3's record, I need to know date of game 4).

What's the best way to get a query to read the next record before the data
gets passed to a report?

Thanks for your help.

Jeff
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"The Mad Russian" <re******************@sympatico.ca> wrote in message news:<uz******************@news20.bellglobal.com>. ..
I have a database that keeps track of hockey games which I work at. In one
table, I have the season's schedule. I want to put together a query that
has the complete schedule, but also I want each record to show when the next
game is (for example, on game 3's record, I need to know date of game 4).

What's the best way to get a query to read the next record before the data
gets passed to a report?

Thanks for your help.

Jeff


put it in the query and use DMIN that's greater than the last game's
date? Then base the report on that... I think.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.