Macro Creating a variable which is to be used in a SQL in the Mac

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Creating Variable and using variable in a SQL statement 4
Excel! How can I use a variable in an autofilter in VBA? 4
How to create a bubble chart with more than 2 variables 0
Passing dates to Sql Server 2005 stored procedure 1
Last Day of the Latest Month Syntax problem 5
Page Header to Include Variable Values 1
New problem! All variables have to be defined? 5
Simple Variable to someone 5

Back
Top