Search results
-
T
SQL date comparision
Hi Mates, Thank you all for looking into it and providing the suggestions. The only way I can make it work is change my date field to text field in database and using the following query: SELECT fbs_tbl.First_Name_Fld, fbs_tbl.Dt_Tm_Fld FROM fbs_tbl WHERE (((fbs_tbl.Dt_Tm_Fld) Between... -
T
SQL date comparision
Right, let me work with design grid. I must be missing something. Thankx a lot. -
T
SQL date comparision
Thankx Rabbie for your reply. I sorted the typo and added a ; at the end, but still no success. My database column type is date/time and short date although I believe it has nothing to do with syntax error. It is making me mad...:confused::mad: -
T
SQL date comparision
Hello Mates, I am trying to do a date comparision in access with the following SQL. select My_Interest_Fld,Title_Fld,First_Name_Fld,Last_Name_Fld,Dt_Tm_Fld from fbs_tbl where Dt_Tm_Fld BETWEEN #01/04/200# AND #31/04/2009# I am getting syntax error message. I at the moment don't have any clue...