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.

 

[bhicks11 via AccessMonster.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

 

[bhicks11 via AccessMonster.com]

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 =---

 

[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.

 

[bhicks11 via AccessMonster.com]

Your welcome.

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

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

[quoted text clipped - 25 lines]
Works for me. Thanks.

----== Posted via Pronews.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.pronews.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= - Total Privacy via Encryption =---