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.