[AccessD] Use of DLookup

Why not just use the Dmax function?

Me.LPD.Value = DMax("[Test Date]", "tbl TestData", "WellNumber = '" &
Me.WellNumber.Value & "'") 

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Monday, March 26, 2012 2:25 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Use of DLookup

Can something this be done with Dlookup or an I way off base. Does not work
as currently off base?

Me.LPD.Value = DLookup("Max(Test Date)", "tbl TestData", "WellNumber = '" &
Me.WellNumber.Value & "'")


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com