[AccessD] Use of DLookup

Thanks to everyone for the help. 
Now all I need is help on remembering the DMAX function.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, March 26, 2012 5:43 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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