| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a value from a variable result | Excel Discussion (Misc queries) | |||
| creating a variable | New Users to Excel | |||
| Macro Creating Variable and using variable in a SQL statement | Excel Programming | |||
| Creating a formula using the loop variable | Excel Programming | |||
| creating macro to ask for variable info when excel starts | Excel Programming | |||
Linear Mode
