Three Date fields

[babak.nourani]

Hi,




I have 3 Date fields in my table.
I want to write a query which shows the records which are older than 2 weeks in any of those dates. In other words I want any of those records to be shown in the query if any of those dates are older than 2 weeks ago.

I don't know how?

What is the easiest way to do that?


I know this is a very easy problem. I would be so thankful if you kindly help me in this.




Best regards
:-)

[June7]

Criteria:

<Date()-14

Put two of the criteria each on a different OR row of the query designer.

[babak.nourani]

OK. But there are 3 Date fields. What about the third one?


Regards.

[June7]

One goes on the Criteria row, the other two each go on separate Or row of the query designer. This result in the SQL would be: This OR This OR This