Do I need zero length string query

[Bentleybelle]

In a database that holds membership records, I have three years worth of info relating to membership dues paid. I want to extract who has not paid a membership fee for the last three years, so we can strike them off our records, i.e. I have members' personal details, but there are no records in the payments table, nothing has been entered because they just have not paid. Do I run a query looking for a zero length string? Just how do I achieve this? Have I done right in not entering anything?

Help appreciated!

 

[FoFa]

Left join the payment table, check for a NULL KEY basically. I think there is a wizard that can assist with that.

 

[Bentleybelle]

Great - done it - thanks very much!