> So, I may try something like:
> SELECT *, recno() FROM mytable INNER JOIN mytable AS my ON mytable.pk=my.pk and mytable.address = my.address and between(mytable.date, my.date-7, my.date+7)

Is pk the primary key? If yes, you only join each record with itself. So, I assume pk is not the primary key.
In this case, it should work if you add a condition to not join the record with itself.

Vlad