querying for first appointment time

[Guest]

I need to query a table of dates that each have multiple appointment times
get the first appointment time for each day in the date range. any
suggestions?

 

[OfficeDev18 via AccessMonster.com]

In your query, use the First or Min aggregate function.

Or am I missing something?

 

[Tom Ellison]

I recommend strongly against FIRST(). MIN() is the correct function.
FIRST() does not refer to "earliest chronologically" which is a sense for
which it is often taken.

Tom Ellison