View Single Post
  #2 (permalink)  
Old February 29th, 2008, 04:49 AM
urtrivedi urtrivedi is offline
Friend of Wrox
 
Join Date: Oct 2007
Location: , , .
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi
Default

"SELECT Accounts.* FROM Accounts WHERE Accounts.datecol = '" & format(rsSociety.Fields("datecol").Value,"dd-MMM-yyyy") & "'"

confirm aruguments of format function, I am not sure about it.

urt

Help yourself by helping someone.
Reply With Quote