Query DLookup Syntax error

[NoLegalMoves via AccessMonster.com]

I have the following column in a query that returns a syntax error.
Any idea why?

Hours: DLookUp("[Hour]","[TB_Productivity]","[Timestamp] =" & [MaxOfTimeStamp]
)

 

[John Spencer]

As a guess your field named timestamp is a date time field. If that is the
case then you need to add the date time delimiter {#) into your Dlookup.


Hours: DLookUp("[Hour]", "[TB_Productivity]", "[Timestamp] = #" &
[MaxOfTimeStamp] & "#")


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[MGFoster]

I have the following column in a query that returns a syntax error.
Any idea why?

Hours: DLookUp("[Hour]","[TB_Productivity]","[Timestamp] =" & [MaxOfTimeStamp]
)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try putting # delimiters around the time data:

"[Timestamp] = #" & [MaxOfTimeStamp] & "#" )

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSrFRC4echKqOuFEgEQIE7gCg3a6vLQgvBj1tBJG1tp9ZjuqNAWgAoKIv
7c2aeHwIqVnIFWK57bkAOKYO
=tx70
-----END PGP SIGNATURE-----

 

[Duane Hookom]

What is the data type of TimeStamp? If it is datetime, try
Hours: DLookUp("[Hour]","[TB_Productivity]","[Timestamp] =#" &
[MaxOfTimeStamp] & "#" )