Hello, Here is my problem: This line opens up my report: DoCmd.OpenReport "rptCalibrationDue", acViewPreview, , _ "tblGages.LastCalib <= #" & dteCalibDue & "#" dteCalibDue is a date entered by the user through an inputbox. tblGages.LastCalib is a field that holds a date. So all records with a LastCalib date that occurred before the date entered show up. However, there is a field called "Interval" on the same table. This interval represents a number of months. Gages are Calibrated every (Interval #) of months. The interval is different for each Gage. What I want to do is add that # of months to the field, LastCalib, so the report will show the records that have a LastCalib + Interval months that are <= (before or on) the user input date. I hope this makes sense. I'll try to give an example: ABC Gage was LastCalibrated 4/1/2006, DEF Gage was LastCalibrated 2/1/2006. ABC Gage has an Interval of 3 (3 months), DEF has an Interval of 10 months. The user enters a date in the inbox of 8/1/2006. ABC WILL be displayed on the report because the total would be 7/1/2006. DEF WILL NOT be displayed on the report because the total would be 12/1/2006. I can answer any questions anyone may have. I really appreciate anyone's attempt to understand this .