I am having a problem with my SQL statement...
Code:stry = "Select * from TabCheckHistory where ClientId = '" & CID & "'" stry = stry & " and Format(CheckDate,'YYYY') = " & LastYear I guess I can't use the format function in SQL????
| CodeGuru Home | VC++ / MFC / C++ | .NET / C# | Visual Basic | VB Forums | Developer.com |
|
Results 1 to 5 of 5
Thread: SqlThreaded View
|
Click Here to Expand Forum to Full Width |