Unanswered: Use form values as dates in query design mode?
In the query designer, is there anything i can put to achieve the following:
"BETWEEN #[Forms]![frmEffCheck]![txtStart]# AND #[Forms]![frmEffCheck]![txtStart]#"
It won't take the  bit as a date (denoted by the #s), so is there any way to seperate the dynamic txtStart and txtEnd values from the comparison? I am currently doing this through code with a querydef, but i'd rather not to prevent my .mdb from bloating up. thanks for the help, as always.