Over 90 days

[paul]

I am using Access 2000. In a report I would like to show a text field
to say "Yes" if the difference between two dates is over 90 days.

Thank you for your help.

 

[paul]

Oops - sorry. Should have given you a report solution.

Make your text box Control Source calculated with the following:

=Iif([orders].[completedate]-[orders].[ordersdate]>90,"Yes","No")

Bonnie
http://www.dataplus-svc.com

Hi Pau:

Here's the SQL:

SELECT "Yes" AS TextField

FROM Orders

WHERE (([orders].[completedate]-[orders].[orderdate]>90));

Bonnie
http://www.dataplus-svc.com

I am using Access 2000. In a report I would like to show a text field
to say "Yes" if the difference between two dates is over 90 days.

[quoted text clipped - 4 lines]

http://www.pronews.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= - Total Privacy via Encryption =---

Works for me. Thanks.