[MS_AccessPros] SQL Syntax Needed to Find Earliest Record

 

Hi
I have a table that has columns Coach, Dist ID, and Last Connect. Each Coach may have multiple rows, differing by Last Connect. I need to find the earliest [Last Connect] for each [Coach] that has [Dist ID] = 4823. I cannot seem to formulate the correct query syntax to get the needed result set.
Any help would be greatly appreciated.
Thanks,
Terryomsn

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 11
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___