Calculated fields in queries

[eddie442]

I have a form that amongst other fields contains a DateOfCalibration field, a CalibrationInterval field and a DateOfNextCalibration field. The DateOfNextCalibration field contents depends on the value that is in the drop down box in the CalibrationInterval field (in months). Is it possible to construct a query that utilises the DateOfNextCalibration field so a user can run a query and enter two dates to find out what equipment will need calibrating between the two dates entered?

I hope that makes sense!

Any help would be greatly appreciated!

Cheers

Dave, England

 

[FoFa]

WHERE DATEADD("m",[CalibrationInterval],[DateOfCalibration]) BETWEEN StartDate AND EndDate

If you are using a date range