How can I store the following query as a variable (the data contorl is datEmployee):
"Select [EmployeeNumber] from EMPLOYEE where [Position] = Customer Assistant"
How do I automatically get the current date in the format dd/mm/yyyy (i.e. 13/11/2003) and assign this to a variable. For example when i click invoice button on a form I want the depature date to be automatically set to the current date.