Hi Guys, I need a SQL query in Access to query the date field in a table and give me a list of dates 30 days before they expire every year.
This is what I tried... SELECT Data_tbl.NameOfClient, Data_tbl.DomainRegDate, DateSerial(Year (DomainRegDate),Month(DomainRegDate)+11,Day(DomainRegDate)) AS In11Month, DateSerial(Year([DomainRegDate]),Month([DomainRegDate])+2,Day ([DomainRegDate])) AS Expr1, Data_tbl.ResellerPartner, Data_tbl.DomainName FROM Data_tbl WHERE (((DateSerial(Year([DomainRegDate]),Month([DomainRegDate])+11,Day ([DomainRegDate])))=[Forms]![DRReminder_frm].[date_cur])); So If a date is 14/11/2004 then on 14/10/2005 the clients name will be displayed in the query. The thing is I need it to check the date EVERY year. At the moment it only appears in the query if the date is less than a year old. Thanks for all your help guys. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
