Pass Input Box VBA Variable to SQL Query

**romperstomper** · 09-14-2011, 03:44 PM

You'll need to format it first, I think:

sSql = sSql & "SET @DATE = '" & Format(report_date, "yyyy-mm-dd") & "'" & vbCrLf

**Zoomer36** · 09-14-2011, 03:53 PM

Hi There!

Thanks! It works like a champ! Really appreciate it.

How about the totaling of the column? I want to put the total in cell C2. This is what I have now from recording a macro

'Figure Totals here and put in cell C2
.Range("C2").Select
.Range("C2").Value = SUM(B2:B125)
.Range("C3").Select

The line where is says Value = SUM(B2:B125) gives me an error. It highlights the colon ":" between the two cell numbers.