Hello i'm new to the forum and in need of some help
I have a table called members and I have a date field called "Date Joined"
What I am wanting to do is have a query that will allow me to check if any members have expired as the memberships only last a year i dont have a expiry field is there any way to autogenerate a expiry date from the Date Joined field in either the query or in the table as a field so if i was to enter 01/01/2011 i would need the expiry date to be generated to show a year later at 01/01/2012. I'm ok to have this on a table field or on the fly on a query as long as I can auto generate it.
I thank the forum in advance for any help they can give me and if you need more information just give me a shout.
Graeme Spence