Macro Creating a variable which is to be used in a SQL in the Mac
see response to previous question
--
HTH
RP
"Jimmy" wrote in message
...
Created a variable by using an input box
eg. StartDate = InputBox("Enter Start Date?", "Report")
Then used this variable in the where clause of the SQL statemnt in the
Macro
eg Date StartDate
Instead of using the variable it tried to put StartDate in the query
instead.
How do i make the statement to look at the variable.
Should the format be in a datetime format as well since this field in the
database is of datetime format. How do i then change the variable to a
datetime format
Thanks to anyone who can help
|