Min MAX function

  • Thread starter Thread starter shivun pilwal
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min Max dates not consistent 5
Min Max Date 7
Updating tables when you input new data 0
share custom calendar wtih mac, export custom fields 1
Max & Min Dates 0
Using Max 2
Equivalent to the Least function in SQL (or min in Excel) 8
Maximum of Two Dates 4

Back
Top