[MSAccessProfessionals] MAX Date in an Expression

Is there a MAX date in Access? I have a Dlookup expression Me.txtCurrentTenant = DLookup("[Name]", "qryCurrentTenant", "[LOCName] = '" & Me.txtUnitID.Value & "'")

I need to add like AND MAX("LeaseStartDate")

Or something like that.

Any ideas

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116189) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_