Use "&", not "+", to concatenate strings, but fullSDate = dtpStartDate, so you don't have to calculate it, and fullEDate is just DateAdd("d", 7, dtpStartDate).

However, tblBooking!Date would have to be the full date, not just "the number for the day", for that code (either way, yours or mine) to work.

What Gary said, though, saves you a lot of work, because you'd only have records that fell between those dates, so you wouldn't have to test anything.