Date query

Results 1 to 2 of 2

Thread: Date query

  1. #1
    Join Date
    Dec 1969

    Default Date query

    I have got a form with two comboboxes containing months. On the next form it should display the no. of students whose birthdays fall between the months selected from comboboxes. I tried a query as follows :<BR><BR> "(Select * from bdays2000 where month(bday) between &#039" & frommonth & "&#039 And &#039" & tomonth & "&#039)" <BR><BR>When I select the month 04 from frommonth combobox and 06 from tomonth combobox, it should display names of students whose birthdays fall in April-may-june.<BR><BR>The above query gives error message as :<BR>ADODB.Recordset (0x800A0E7D)<BR>Operation is not allowed on an object referencing a closed or invalid connection.<BR><BR><BR>Can u help me?<BR>

  2. #2
    Join Date
    Dec 1969

    Default show more code...

    i need to see all of the connection code & recordset code because this error is not pointing to your syntax, it is pointing to your connection...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts