membership renewal letter.

[rob_jeffers]

Ok the database that i have contain all the details about customers including thier joining date. I want to make a query that will produce relevant information for use on a membership renewal letter, It should show only members due for renewal on 1st of may
(there are 3 renewal dates per year. 1st jan , 1st may and 1st sept. I need to assume that the next renewal month of membership for those joining between those months will be the next renewal date. Example if you join in June your renewal date would be 1st september)

Could you please explain how i could do this in easy to understand language as i am no expert with access.

Thanks

 

[dheich4321]

You could use a nested IF function to solve the problem