expiry date query help

[graemespence1]

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

[alansidman]

Graeme;
In a new column (field) in your QBE, type the following

Expired: iif(Date()>DateAdd("yyyy",1,[Date Joined]),"Expired","Current")

Now in the criteria for this same field type the following

= Expired

Run the query. You should get the results of all expirations.

Alan

[graemespence1]

Thanks that worked is there any way i can show the xpired date so if my start date was
01/01/2010 so the generated expiry date would be 01/01/2011 is there i way i can see that date oir not no worry if i cant

[alansidman]

In a new column type: ExpiryDate: DateAdd("yyyy",1,[Date Joined])

Look here for information on DateAdd Function

http://www.techonthenet.com/access/f...te/dateadd.php