I have a code that sets all dates before 01.01.2003, expressed with <#1/1/2002 like that:
" WHERE (((orders.orderdate)<#1/1/2002#));"
Is it possible to enable the user to choose the dates in a form ? For example, build a table
called Table1 ,and a field called Fiel1 then a form called Form1 and then obtain the date in the expression
from the date in the form.Somehing like that:
< Forms![Form1]![Field1]
In this way the user will be able to set the dates himself without writing the code <#1/1/2002#
Is it possible ?