ASP AND MS ACCESS

Question

set rs5 = objconn.execute("Select Sing from LeaveEntitlement where MonthEntitle = '"& Month(ttodate)& " ' ")                
do until rs5.eof   
  if rs5("Sing") then   
  s = rs5("Sing")  
Loop

In the Database table LeaveEntitlement, MonthEntitle is a Field Nmae(Text Data type) from January...December.Sing is another Field(Number Data type) with values for each Month.But S is returning nothing.

Can help for solving this.

Oded, Thanks a lot for solving my issue.

Answer 1

There are probably no rows in the table corresponding to the month you are searching on.

Have you checked directly against the database that the query is returning any rows?

Edit:

It appears that you are using month names in your database, however the Month function returns a month number. You are enclosing that in ', so you are sending a string with the number in the query - this is why you do not get a type error and why no results are being returned.

You can use MonthName with Month:

where MonthEntitle = '" & MonthName(Month(ttodate)) & "' "

Answer 2

Just taking a stab in the dark it looks like you have an extra space at the end of your sql where you put in the month name. Probably not matching any records.