dear All
hi after long time.i am facing one strange problem in VBA query.in query when i pass only (ABC.STOCK_MOVE_HD.TRANS_DATE >= '" & p & "' ) this parameter it is working fine but
when i pass with this (ABC.STOCK_MOVE_HD.TRANS_DATE >= '" & p & "' AND ABC.STOCK_MOVE_HD.TRANS_DATE >= '" & pto & "' ) it is giving me error message "DATA Type Mismatch" .

.CommandText = Array( _
"select ABC.STOCK_MOVE_DT.ITEM_ID as ""ITEM"", " & Chr(10) & "ABC.STOCK_MOVE_DT.LINE_NO as ""LINENUM"", " & Chr(10) & "ABC.STOCK_MOVE_DT.QTY as ""QTYSHIPPED"", " & Chr(10) & "ABC.STOCK_MOVE_DT.UNIT_PRICE as ""PRIUNTPRC"", " & Chr(10) & "ABC.STOCK_MOVE_HD.TRANS_DATE as ""SHIDATE"", " _
, _
"" & Chr(10) & "ABC.STOCK_MOVE_HD.TRANS_NO as ""SHIUNIQ"" " & Chr(10) & "from ABC.STOCK_MOVE_DT, ABC.STOCK_MOVE_HD" & Chr(10) & "WHERE ( ABC.STOCK_MOVE_DT.HD_ID = ABC.STOCK_MOVE_HD.ID AND ABC.STOCK_MOVE_HD.TRANS_TYPE <> 2 AND ABC.STOCK_MOVE_HD.TRANS_DATE >= '" & p & "' AND ABC.STOCK_MOVE_HD.TRANS_DATE >= '" & pto & "' )" _
)

best regards
Mazahir