Search results

I have a membership table with a joined date field. I need help with a query that will show membership expired after one year. Additionally, I need a query to show me Board Members who haven't paid their yearly fee.

I have over 500 members. I already created two tables which are a membership and member type How would I create a query in Access that will let me know when the membership expires based on the following $35=1year membership - $100 = 2years - $250 = 3years? I do not know where to begin...