querying for first appointment time

W

WillBe52

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?
 
O

OfficeDev18 via AccessMonster.com

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

Or am I missing something?
 
T

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
 
Top