J Jim Pockmire Jan 31, 2007 #1 How would I construct a Dlookup statement to locate a specific date in a table based on a date on a form?
How would I construct a Dlookup statement to locate a specific date in a table based on a date on a form?
G Guest Jan 31, 2007 #2 Hi Jim, Something like this: dlookup("DATEFIELD", "TABLENAME", "[DATEFIELD] = #" & format(me.DATEONFORM, "yyyy/mm/dd") & "#") Hope this helps. Damian.
Hi Jim, Something like this: dlookup("DATEFIELD", "TABLENAME", "[DATEFIELD] = #" & format(me.DATEONFORM, "yyyy/mm/dd") & "#") Hope this helps. Damian.
