We recently got a new set of servers and upgraded our Office 2003 to 2007. I have a proprietary database written in Access that is used to keep track of clients. One of the reports that used to run correctly in Access 2003 calculates when a client needs a 90 day update. It’s based on the last update date in their record. When I check to see if the last update date + 90 days is less than today’s date + 30 days (to get the list a little shorter), it doesn’t calculate out correctly any more. I was wondering if they did something to change the way dates are handled in Access 2007? The Update date is in a query and I had the expression <= Date()+30 to check it. I get some of the records, and miss a whole lot more and am not sure why this has changed. Any help is appreciated. Thanks.
