 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / October 2007Dlookup and Dates
I have the following field in a query. DLookUp("gl_perod_id","ingres_gl_perod_tbl","[gl_perod_stdt]<=" & Format([BegDate],"\#mm\/dd\/yyyy\#") & " and [gl_perod_enddt]>=" & Format([BegDate],"\#mm\/dd\/yyyy\#")) It keeps on giving me #Error. Any ideas or suggestions? I am using Access 2003.  SignatureM. Shipp I solved the problem. The function should be.... DLookUp("gl_perod_id","ingres_gl_perod_tbl","cdate([gl_perod_stdt])<= " & Format([BegDate],"\#mm\/dd\/yyyy\#") & " and cdate([gl_perod_enddt])>= " & Format([BegDate],"\#mm\/dd\/yyyy\#")) SignatureM. Shipp > I have the following field in a query. > [quoted text clipped - 4 lines] > It keeps on giving me #Error. Any ideas or suggestions? I am using Access > 2003. Even better (more portable) is using military Format ie yyyy-mm-dd HtH Pieter >I solved the problem. > [quoted text clipped - 12 lines] >> It keeps on giving me #Error. Any ideas or suggestions? I am using Access >> 2003. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.