Min MAX function

S

shivun pilwal

Does anyone have any examples of this being used in access. I have a date
field in table 2 that I need latest date from for each customer in the
cusomter table.


regards

shivun
 
A

Allen Browne

1. Create a query.

2. Depress the Total button on the toolbar.
Access adds a Total row to the design grid.

3. Add the CustomerID field to Field row.
Accept Group By in the Total row under this field.

4. Add the date field to the Field row.
In the Total row under this field, choose Max.
 
Top