I have a client table, and a detail table. Each client has a set of details which are transactions they made. How do I find the most recent Transaction in the detail table? Each transaction has a date. What kind of statement would find the most recent date in a set of records?
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you find the most Recent Date with Query??
- Thread starter jmorlock
- Start date
- Status
Similar threads
- Locked
- Question
