DLookup question....

  • Thread starter Thread starter Edo2008
  • Start date Start date
E

Edo2008

The following statement gives me a Runtime Error 94: Invalid use of
Null:

dim intVisitID as integer

intVisitID= DLookup("VisitID", "Visits", "[VisitDate] =
3/8/2008")

I'm trying to see if any table entries is Table "Visits" have a
"VisitDate" entry (which has a Date/Time format) equal to today. As a
test case, I hardcoded today's date... my next step was to use the
"Date()" function. Note that all 5 entries in teh Visits table have
date/time values.

Can anyone help?

Thanks
-Ed
 
Edo2008 said:
The following statement gives me a Runtime Error 94: Invalid use of
Null:

dim intVisitID as integer

intVisitID= DLookup("VisitID", "Visits", "[VisitDate] =
3/8/2008")

I'm trying to see if any table entries is Table "Visits" have a
"VisitDate" entry (which has a Date/Time format) equal to today. As a
test case, I hardcoded today's date... my next step was to use the
"Date()" function. Note that all 5 entries in teh Visits table have
date/time values.

Can anyone help?
Click to expand...

Have you tried this?

intVisitID= DLookup("VisitID", "Visits", "[VisitDate] >= # 3/8/2008#")

Tom Lake
 
THANK YOU !!! It worked like a charm !

I LOVE GOOGLE GOUPS !!!

Thank you so much for taking the time to answer. It is unbelievable
the amount of help newgroups provide and I do not take it for
granted !!

-Ed
 
Back
Top