Need help with sql 1

[FireViking]

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.

 

[KenReay]

Hi

Assuming Region is not a date type column

If it is a string type:

strNotChartCount = "SELECT * FROM tblnotice WHERE Region = '" & strRegion & "' and IssuedDate BETWEEN #" & strStartDate & "# AND #" & strEndDate & "#"

If it is a numeric:

strNotChartCount = "SELECT * FROM tblnotice WHERE Region = " & strRegion & " and IssuedDate BETWEEN #" & strStartDate & "# AND #" & strEndDate & "#"

and finally, be aware dates must be presented within SQL statemenst in US format, ie mm/dd/yy, so if you are not in the USA you may also need to reformat your dates so:

Format(strStartDate,"mm/dd/yy&quot

Hope this helps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[FireViking]

Hi,
Thanks for that, I didnt realise I had used the date syntax. Big day and started to get frustrated. Thanks for the tips.

Cheers