RE: Can I do this with a Query?

Thanks for your help. I've been trying to work through your recommendation and ran into one more problem. Rather than simply trying to lookup one TEAM (I'm typing column titles in caps for clarity) and look 3 GAMEs back to see what SURFACE they played on, I'm trying to find all the GAMEs where a

Can I do this with a Query?

I have a database of NFL data. The majority of the data is stored in a single table, with each row of data containing various info on each game played. A very simplified version looks like this: ID TEAM OPPONENT GAME SEASON SURFACE 5 NY Giants