hi guys, i have a query that pulls info from two tables.
i searched this issue but the 2 solutions i found did not work for me.
i have a Between And criteria on the date field; it pulls the effective month/day range, but it also pulls all of the years.
so instead of having records for only 4/1/12 and 4/25/12, i get records from all of the years. 4/1/1990 - 4/25/2012.
this is my query:
SELECT CDate(Format([PLAT_DATE],"mm/dd/yyyy")) AS Expr1, DIOD_DTA.PART_NUM, DIOD_DTA.LOT_NUM, PLATINUM.PLAT_TEMP, PLATINUM.PLAT_DOP, PLATINUM.PLAT_DOPANT_LOT, DIOD_DTA.TRR_AVE, DIOD_DTA.PIV_AVE, DIOD_DTA.IR_AVE, DIOD_DTA.PERC_PIV, DIOD_DTA.PERC_IR, DIOD_DTA.PERC_VF, DIOD_DTA.PERC_TRR, DIOD_DTA.NUM_TESTED, DIOD_DTA.VF_AVE
FROM DIOD_DTA INNER JOIN PLATINUM ON DIOD_DTA.LOT_NUM = PLATINUM.LOT_NUM
WHERE (((CDate(Format([PLAT_DATE],"mm/dd/yyyy"))) Between [Forms]![frm_SelectInfo]![txtStart] And [Forms]![frm_SelectInfo]![txtEnd]))
ORDER BY PLATINUM.PLAT_DOP DESC;
i have used this criteria many times, i'm not sure what the problem is.