-
Help with a Query
I have put together a database of my favorite basketball team. Each record is a game played. I wanted to query results on how the team has performed off a loss or off a win or when they were home off 3 straight away games. I assume it would have to be a subquery of some sort, but can not figure one out.
Say my table would look something like this.
ID (primary key), DATE, SITE, TEAM, RESULT, PF, PA
200701 12/01/2007 A Southern W 68 51
200702 12/03/2007 A Northern L 54 58
200703 12/05/2007 A Eastern W 77 76
200704 12/07/2007 H Western L 59 78
How would I query those examples I have listed above which are based off the previous record(s).
Any help from anyone would be greatly appreciated.
Thank you again for time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|