Error in Query on Access DB

  • Thread starter Thread starter Arthur Erdös
  • Start date Start date
A

Arthur Erdös

Hi NG,

I get a runtime error in following Syntax:

RS.Open Source:="SELECT v_ID FROM verwbuch WHERE mb_ID = 5 AND (dDatum
BETWEEN #01.01.2003# AND #31.12.2003)", ActiveConnection:="DSN=MyDsn",
CursorType:=adOpenKeyset

Does BETWEEN not work with Access?? Please help, any idea is appreciated!

thx in advance!

Arthur
 
sry, the # was missing only in this NG-post, it wasn't the cause for the
error. The problem was that dates have to be in US format, like
" ... BETWEEN #01/01/2003# AND #12/31/2003"

thx!
 
Back
Top