G
Guest
In the following sql statement, start_date_cal.Value and end_date_cal.Value
are coming from calendar objects. The values are ok and displayed in text
boxes. When I try this sql statement, I get a syntax error " can't find
field | in expression". What am I doing wrong? Thanks.
strSQL = "select * " _
& "where DATE Between " _
& "#[start_date_cal.value]# And #[end_date_cal.value]#;"
are coming from calendar objects. The values are ok and displayed in text
boxes. When I try this sql statement, I get a syntax error " can't find
field | in expression". What am I doing wrong? Thanks.
strSQL = "select * " _
& "where DATE Between " _
& "#[start_date_cal.value]# And #[end_date_cal.value]#;"