I am new to access trying to set up database for a nonprofit. I’m in the design phase so have not actually started in access. I have folks that join as a member then leave and then return. I assume I need a separate table to deal with this but how do I set up the fields to be able to query current membership status?
