[AccessD] Use of DLookup

I wish I had a dollar for every problem that I have seen caused by spaces in Field etc names.
Why DO people do it?   Try:


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

-- 
Stuart

On 26 Mar 2012 at 16:24, Kaup, Chester wrote:

> 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
>