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 dates. Creating a simple query using the 2 tables linked with the person's ID field, and with the criteria Not Between [date 1] and [date 2] as the criteria doesn't return the expected results.
I was thinking that it may be better to use a query to make a table with the people who *have* paid between those dates and then subtract them from the remainder to yield those who haven't paid.
I'm not sure if this makes sense or is a good idea and if it is, how to do it. Or maybe there's a better way?
Thanks for any ideas.
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 dates. Creating a simple query using the 2 tables linked with the person's ID field, and with the criteria Not Between [date 1] and [date 2] as the criteria doesn't return the expected results.
I was thinking that it may be better to use a query to make a table with the people who *have* paid between those dates and then subtract them from the remainder to yield those who haven't paid.
I'm not sure if this makes sense or is a good idea and if it is, how to do it. Or maybe there's a better way?
Thanks for any ideas.