这样试试
cmd.CommandText="SELECT * FROM {物品入库} where 入库单编码 >= " & kc.value & " And 入库单编码 <= " & jc.value