Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Find record between records
Without knowing 100% what that SQL query does exactly, I'd venture to guess that this won't work. Unfortunately I forgot to mention that there could be many entries between the state=0 and the person's name, so sample records could look like this: ID Action 0 state=0 1 carl 2 barry 3...- veeRob
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Find record between records
To give you a little background, I am a VB6 programmer but have little experience with Microsoft Access. I have a VB6 program that does a little crunching of my database to return some info. For example, my database looks like this: ID Action 0 state=0 1 alan 2 barry 3 state=1 4...- veeRob
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
