I am trying to create a report as follows, but don't know how to.

I have a list of bookings and I find all the bookings for a particular week.
No problem there.

Then, I want to use the client for each of these bookings and find out all the bookings previously for this client, but only for clients who have a booking for the specified week.

So, to clarify, for next week I have 127 bookings and for each of these bookings I want to see if the client has booked previously.



Currently I am just finding the bookings for the specified week, but don't know how to do the 2nd query.

I guess what I need is to do a 2nd WHERE statement which is different from the 1st one, but on the same table.
Thanks fir any help.