MSAccess
-
I have a table Tab1 with fields Name and Dt( data type Date/Time). the col Dt have values 2/2/2007 3/3/2007 5/5/2008 i want to display names with date before 1/1/2008 i wrote the folowing query "SELECT Name from tab1 where dt < 1/1/2008" but this returns nothing.. iam using msaccess 2003. thanks
-
I have a table Tab1 with fields Name and Dt( data type Date/Time). the col Dt have values 2/2/2007 3/3/2007 5/5/2008 i want to display names with date before 1/1/2008 i wrote the folowing query "SELECT Name from tab1 where dt < 1/1/2008" but this returns nothing.. iam using msaccess 2003. thanks
I think in Access you have to surround date/time literals with the # sign. Try:
"SELECT Name from tab1 where dt < #1/1/2008#" -
I think in Access you have to surround date/time literals with the # sign. Try:
"SELECT Name from tab1 where dt < #1/1/2008#" -
I have a table Tab1 with fields Name and Dt( data type Date/Time). the col Dt have values 2/2/2007 3/3/2007 5/5/2008 i want to display names with date before 1/1/2008 i wrote the folowing query "SELECT Name from tab1 where dt < 1/1/2008" but this returns nothing.. iam using msaccess 2003. thanks
Hello there, the correct query is here SELECT Name from tab1 where dt < #1/1/2008#
Rahul Goel Microsoft Cerfied Solution Developer .Net Contact me at : rahul.g2510@gmail.com