[MS_AccessPros] Re: SQL Syntax Needed to Find Earliest Record

 

Try:
SELECT Coach, [Dist ID],[Last Connect]
FROM [TableWIthNoName]
WHERE [Dist ID]=4823 and
[Last Connect] IN (SELECT TOP 1 [Last Connect] FROM [TableWithNoName] t WHERE t.Coach = [TableWithNoName].Coach ORDER BY [Last Connect]);

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, "Terry Olsen" <terryomsn@...> wrote:
>
> 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 (2)

Recent Activity:

• New Members 11
• New Files 4

Visit Your Group

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

.

__,_._,___