搞定了

原先條件是這樣的
sql = "Select * from Product where PartName= '" & Team(25) & "' and Produdate Between #" & STARTDAY & "# And #" & ENDDAY & "# Order by Produdate,ProduTime,PartName "

Team(25)=物件名稱
Produdate=日期
ProduTime=時間

後來我改成這樣後有個問題，超過一天他的紀錄方式會不對
sql = "Select * from Product where PartName= '" & Team(25) & "' and Produdate Between #" & STARTDAY & "# And #" & ENDDAY & "# and ProduTime Between #" & STARTTIME & "# And #" & ENDTIME & "# Order by Produdate,ProduTime,PartName "


後來我改成兩段式寫法就OK了
IF STARTDAY=ENDDAY then

sql = "Select * from Product where PartName= '" & Team(25) & "' and Produdate Between #" & STARTDAY & "# And #" & ENDDAY & "# and ProduTime Between #" & STARTTIME & "# And #" & ENDTIME & "# Order by Produdate,ProduTime,PartName "

elae

sql = "Select * from Product where PartName= '" & Team(25) & "' and Produdate Between #" & STARTDAY & "# And #" & STARTDAY & "# and ProduTime Between #" & STARTTIME & "# And #" & 23:59:59 & "# Order by Produdate,ProduTime,PartName "
..............
sql = "Select * from Product where PartName= '" & Team(25) & "' and Produdate Between #" & (STARTDAY+1) & "# And #" & ENDDAY & "# Order by Produdate,ProduTime,PartName "

END IF