cmd.CommandText = "SELECT * FROM {MO} as m1 inner join {ITEM} as i1 on m1.ITEM_ID=i1.ITEM_BUSINESS_ID WHERE m1.[STATUS] in ('y','Y','3') And m1.[DOC_DATE] between #" & date1 & "# And #" & date2 & "# ORDER BY m1.DOC_DATE"