Hi ernie -
In Access there is a built-in function called
DateDiff. The Access help pages do a nice job discussing DateDiff, but I'll just say that in your case you'll want to write out the criteria to be something like
- Abs(DateDiff("d", Now(), [promise date])) <= 3
Here, "d" just means that you want whole days to be the time interval that the function works with. Of course, there are other important details, like whether you are doing this in Query Design view, or in VBA code. Let me know some more of how you're trying to accomplish this and I can fine-tune the answer for you.
And, as an aside, seeing that you were programming back in 1964, would any of your experience happen to have been with FORTRAN?
Pat