M
Mike C
I have a pass through query that has a date criteria in it. I want to change
it so that it looks at a form for the date.
Pass Through Criteria 1 (Working)
WHERE (((O101IA.TRETSER.PKG_SCH_RTN_DT)=TO_DATE('01/10/2005','MM/DD/YYYY')))
Pass Through Criteria 2 (Does not work)
WHERE (((O101IA.TRETSER.PKG_SCH_RTN_DT)=[Forms]![main]![txt_oo]))
Any ideas or suggestions would be greatly appreciated, thank in advance.
it so that it looks at a form for the date.
Pass Through Criteria 1 (Working)
WHERE (((O101IA.TRETSER.PKG_SCH_RTN_DT)=TO_DATE('01/10/2005','MM/DD/YYYY')))
Pass Through Criteria 2 (Does not work)
WHERE (((O101IA.TRETSER.PKG_SCH_RTN_DT)=[Forms]![main]![txt_oo]))
Any ideas or suggestions would be greatly appreciated, thank in advance.