Recent content by seven11

What you will want to check for is the following: If (RS.EOF and RS.BOF) Then 'do logic here to display no records message else 'do logic here to display your records end if When a recordset returns empty, the End of File (EOF) and Beginning of File (BOF) attributes of the recordset...

Have you tried this? select count(*) from tblDates where dates in (select dates from tblSundays)

Most likely what you will have to do is check to see what the control type is first before you try to access the property. If the control is something that can have a old value, then perform the comparison, else move to the next control. good luck - 711

You might want to check Crystal Reports or Active Reports. I am assuming that you are using a Microsoft Internet Information Server (IIS). If so, then you will be able to execute Active Server Pages and in turn, Crystal and Active Reports. Good Luck 711

Here is the query that will generate the information you want: SELECT Main.Color, count(color) FROM Main group by color;