sql statement not working in code, will work when in query 1

[lwilly]

I have this sql statement in a module

strSQL = "SELECT SUM (IVC_QTY * InvoiceUnitPrice)AS Sales"
strSQL = strSQL & " FROM tblSalesDbMaster"
strSQL = strSQL & " WHERE IVC_DATE >= " & dteBegin
strSQL = strSQL & &quot; AND IVC_DATE <= &quot; & dteEnd

Set rst = dbs.OpenRecordset(strSQL)

GetTotalSales = rst![Sales]

When run this statement it returns a null value. When I debug this statement and paste it into a query it returns the number I am looking for. Can someone explain why it works one way but not the other.

Thanks

 

[Rick39]

Try:

strSQL = &quot;SELECT SUM (IVC_QTY * InvoiceUnitPrice)AS Sales&quot;
strSQL = strSQL & &quot; FROM tblSalesDbMaster&quot;
strSQL = strSQL & &quot; WHERE IVC_DATE >= #&quot; & dteBegin & &quot;#&quot;
strSQL = strSQL & &quot; AND IVC_DATE <= #&quot; & dteEnd & &quot;#;&quot;

 

[lwilly]

Thanks for the quick response. Your response was correct and I appreciate you pointing out the errors of my ways.