I am trying to write a query with access WEBAPPS to show training records where the review date is within 90 days of the current date. It appears that TODAY must be used not DATE because of the SQL Server interface but I still cannot get this simple query working. The field does contain empty fields with no date in, if perhaps this might be causing some of the problem. I am sure this must be a very simple fix, but I really cannot see what I am doing wrong. Any help gratefully received.