Hi, I am going round in circles and unfortunately don't know enough about the query builder or SQL (or if these are even going to help!) to resolve my issue.
I have a club membership database which i have made (steep learning curve for me so far!) which I need some help with, if anyone could help with the below I would be eternally grateful. I have a form in which I have inseted a check box for lapsed members however I would like to have an auto-calculation (if possible) so I do not have to manually mark people as overdue/lapsed. Can I put a macro or something in the form that will cross reference the renewal date and todays date and mark the record lapsed (by way of the check box?)if the date today is later than the renewal??? Is there anyway this can be done? And if so, help with the code/how to do it would be greatly appreciated. I have looked online but everything I have tried so far has failed miserably!
