Access 2007-2019 Access 2000-2003 Access Seminars TechHelp Support Tips & Tricks Access Forum Course Index Topic Glossary Insider Circle

 Home   News   Courses   TechHelp   Templates   Forums   Help   Order   Contact   Logon More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

 Access    Excel    Word    Windows    HTML

# DMax

## Using the DMAX Function

In this tutorial you will learn how to use the DMAX Function.

Take an example Table of Customers.

CustomerT
CustomerIDFirstNameLastNamePhoneCustomerSinceCreditLimitDaysGraceIsActive
1RichardRost716555777701/01/201210011True
2JoeSmith716555343401/03/19905005True
3SuzanJones562436514602/01/199815002False
4AlanWatson419389121217/05/2012503True
5AnnaPicore71323647905/05/200510204True
6RonaldSimms780746546804/04/1992502True
7DonaldBarker416441555501/03/19982505True
8BennySperduti716726726206/04/199916007False
9PeteSmith564559777704/04/20005003False
10BarbraPeters829282728831/12/2005501True
11JoeJones549546546601/06/20045003True
14PezzDispo26/09/201204True
16BobSmith04/10/201209True

For this example we wish to find out the most recent Customer in our list. For this case we don't need a Criteria instead we are just going to get the Field of CustomerSince from the Domain of CustomerT and return the latest value from the whole set.

The DMAX function returns a value from a specified set of records (or domain) containing the maximum value.

=DMAX(Field, Domain, Criteria)

Query

The results using a Query would be

```	SELECT TOP 1 CustomerSince FROM CustomerT ORDER BY CustomerSince DESC
```
tblNames
CustomerIDFirstNameLastNamePhoneCustomerSinceCreditLimitDaysGraceIsActive
16BobSmith04/10/201209True

FORM

In a Form you could set the Default Value of a Textbox to

```	=DMAX("CusomterSince", "CustomerT", )
```
VBA

In a Form add a TEXTBOX control and rename it "txtDMax", then you could add the following in the Load Event.

```	Private Sub Form_Load()
txtDMax = DMax("CusomterSince", "CustomerT", )
End Sub
```

Course Tip

See this FREE Tip on DMAX (Incrementing your own Counter).

Search