Recent content by Carolyn2bu

Thank you very much!!!! That time it work. I appreciate your assistance in helping me resolve my query problem.

Thank you so much for helping me with my query problem. Below are a few results of the query. As you can see there was no date return. I would prefer the results to return an expiration date. I have over 500 members listed. Some of the membership has been expired since 2009 or later. I am trying...

Below are the results of the query. As you can see there was no date return and some of the membership has not expired yet. I have over 500 members listed. Some of the membership has been expired since 2009 or later. I am trying to pull those and solicit them to rejoin. Query2 FIRST_NAME...

It's not showing the expiration date. I enter DateAdd("yyyy", 1, JoinDate) < Date() in the querry field nent to the join date. Nothing shows up in the expiration column.

MEMBERS TABLE - I need to know when membership expired after one year TITLE - Field 1 FIRST_NAME- Field 2 LAST_NAME- Field 3 ADDRESS Field 4 CITY- Field5 STATE- Field6 ZIPCODE- Field7 TELEPHONE - Field8 EMAIL_ADDRESS- Field9 DateJoined- Field10 MEMBERDUES- Field11 MEMBER_TYPE -...

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.

Thank you so much that helped a lot. I need help with another situation.

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...