SELECT tb訂做西服.訂單編號, tb訂做西服.量身業務, Format([量身日期],"yyyy/mm/dd") AS 量身年月
FROM tb訂做西服
WHERE (((tb訂做西服.量身業務) Like [forms]![new]![量身業務] & "*") AND ((Format([量身日期],"yyyy-mm-dd")) Between IIf(IsNull([forms]![new]![BDate]),#1/1/1990#,[forms]![new]![BDate]) And IIf(IsNull([forms]![new]![EDate]),#12/31/2040#,[forms]![new]![EDate])));