This is probably the harder way to do this.
VB Code:
  1. While not Found and not tblBooking.EOF
  2.    If tblBooking!Date >= startate and If tblBooking!Date <=EndDate then
  3.       Do what you want here
  4.    end if
  5.    tblBooking.MoveNext
  6. Wend