FireViking
Programmer
Hi,
I am trying to create an sql with to criteria. 1. being the region and 2. between dates.
strNotChartCount = "SELECT * FROM tblnotice WHERE Region = #" & strRegion & "# and IssuedDate BETWEEN #" & strStartDate & "# AND #" & strEndDate & "#"
The syntax is not quite right and need assistance.
I am trying to create an sql with to criteria. 1. being the region and 2. between dates.
strNotChartCount = "SELECT * FROM tblnotice WHERE Region = #" & strRegion & "# and IssuedDate BETWEEN #" & strStartDate & "# AND #" & strEndDate & "#"
The syntax is not quite right and need assistance.