Hi,
I am trying to retreive some records after a certain date in exce
using VBA. The database is MS access. I am using the following query
it gives an error.
Select * from Datatable
where ModDate format('01/21/2006', '\#mm/dd/yyyy\#').
Could somebody enlighten me how to use the date field in wher clause.
Thanks in advance for your help.
regards
Anan
--
anandmr6
-----------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...fo&userid=3072
View this thread:
http://www.excelforum.com/showthread.php?threadid=53915