Recent content by Tangawizi

Thanks so much for your help, it's really appreciated. Hopefully I'll be able get things working now.

Can you please tell me how to pass the start and end dates, which are chosen from a form, to the sql query?

In a nutshell, I'm trying to create a report showing who hasn't made a payment between a selected date range, that's it.

Yes, but the query returns all the people who haven't paid between the date range (great, this is what I want), but also all the people who have paid outside the range, which I don't want.

The trouble is that is also returns records of people who paid on dates outside the selected range.

Noted, thanks. Two things I'm not sure about: 1. how to check for and delete the temporary table on subsequent runs of the report; and 2. how to 'subtract' one table from another.

Hi, I'd be very grateful if someone could point me in the right direction regarding this query. I have a table consisting of people's details and another which tracks payments they've made. I'm trying to design a report which shows the people who *haven't* made a payment between 2 specified...