Hello. I have created a recordset that uses the following WHERE clause
WHERE (((paylines.date)>Now()-Weekday(Now()-1)-14 And (paylines.date)<Now()-Weekday(Now()-1)))
I would like to change the WHERE clause to be based on a form control. I know I can't use the following:
WHERE...
