I have a query where I am using the MIN function to filter out duplicate Call Numbers (Call_No). The query works well and returns 34 records -- perfect. Here it is:

Code:
SELECT RV_CALL_HISTORY.Call_No as "Call Number",
MIN(RV_CALL_HISTORY.Call_Log_Date) as "Call Log Date",
MIN(RV_CALL_HISTORY.Call_Hist_Date) as "Call Hist Date"
FROM RV_CALL_HISTORY
WHERE
RV_CALL_HISTORY.Call_Log_Date
...