[AccessD] Dlookup syntax

You either need to dim X as a variant or use an Nz function around
Dlookup.  Integers aren't especially fond of being set to Null, which is
what Dlookup returns if there is no matching value.

Charlotte Foust

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Tuesday, July 20, 2004 12:32 PM
To: AccessD
Subject: [AccessD] Dlookup syntax


I can't remember how to format this! Bloddy L. The second thing to go is
memory. I forget what the first is.

Dim s as string
Dim x as Integer
Dim d as Date

d = Date()
X = Dlookup("myColumn", "myTable", "myDateColumn=#" & d & "#")

Doesn't seem to work. What should I be doing instead?

TIA,
Arthur



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