I need a query that goes between two dates. The problem is the second date is not a static date. It is 90 days from the first date.

I thought the parameter should go like this:

Between [AUDIT_SETUP]![FirstMailDate] And [AUDIT_SETUP]![FirstMailDate]+90

Am I correct?

Naomi-

Since you have the application in front of you, why not give your idea a try? If it doesn't work then post back with the details.

Please don't expect responders to build a similar scenario and test it when you haven't even tried it yourself.

Bob

you dont have to be so mean. it was a common knowledge question. try to be more positive please!!!!!

Dearest Naomi-

I do apoligize profusely for offending your delicate sensibilities!

You must understand that I'm old and cranky and tired and was brought up in a bygone era where folks were encouraged to first try to do their best to solve a problem and then, and only then, look to others for assistance in resolving their outstanding issues.

Your friend,

Bob ...the mean old--not to mention 'insensitive'--dinosaur

Try this

Between [AUDIT_SETUP]![FirstMailDate] And DateAdd("d",90,[AUDIT_SETUP]![FirstMailDate])