[AccessD] Use of DLookup

Chester,
I recommend you create a query to find the Max Test Date then use the
DLookup function.  DLookup will look at the first set quotes as a specific
field, not a function and field.

The other option is to use the DMax function.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Monday, March 26, 2012 4: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