Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creating a variable which is to be used in a SQL in the Mac
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a variable | New Users to Excel | |||
Macro Creating Variable and using variable in a SQL statement | Excel Programming | |||
Macro Creating a variable which is to be used in a SQL in the Mac | Excel Programming | |||
Macro Creating a variable which is to be used in a SQL in the Mac | Excel Programming | |||
creating macro to ask for variable info when excel starts | Excel Programming |