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 strongm 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 Woodbadge
-
MAX Transaction for each Individual
Thanks RAC2, that's done excatly what I wanted and has help me better understand sub queries with summary functions. Really appreciate your help. -
MAX Transaction for each Individual
I have a table of individuals and another table of transactions relating to those individuals. I want to find the most recent transaction for each individual in the database. I have tried the following but this only gives me data for the most recent transaction in the database, not the most...
