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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Mike922
-
Records immediately before and after dates that are within groups
Thanks to both of you for your help. Based in part upon your responses, I may have figured out a solution on my own using multiple queries created with the QBE grid. I'm in the process of testing it out today. I've printed out your sample code for guidance. Much appreciated.- Mike922
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Records immediately before and after dates that are within groups
I need to come up with a query in Access 2k that kind of mirrors this scenario --- Using Northwind as an example. First I'd like to see all of the orders which exceed a specified amount, say $4000. Out of that group of "big" customers, I want to know the average amount they spent on the order...- Mike922
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
