[AccessD] Dlookup syntax

Arthur
How's it failing?

May be worth trying:

X = Dlookup("myColumn", "myTable", "myDateColumn=#" & Format(d,"mm/dd/yy") &
"#")

Or, as Charlotte suggests:

X = Nz(Dlookup("myColumn", "myTable", "myDateColumn=#" &
Format(d,"mm/dd/yy") & "#"),0)

-- Andy Lacey
http://www.minstersystems.co.uk 



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Arthur Fuller
> Sent: 20 July 2004 21:32
> 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/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>