Data in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

halima - 02 Dec 2005 10:11 GMT

Goodmorning,

In my query I have a Bill date, I would like to know how I can have all
bills < than 90 days as well as all bills > than 90 days

Thanks!

Reply to this Message

halima - 02 Dec 2005 11:10 GMT

I tried to solve the problem by using the condition where in my query

"where bill_date"<="bill date"+"90" but I would like to know whether it is
sufficient knowing that it also concerns aging bills from 1994.

Thank you!

> Goodmorning,
>
> In my query I have a Bill date, I would like to know how I can have all
> bills < than 90 days as well as all bills > than 90 days
>
> Thanks!

Reply to this Message

Michel Walsh - 02 Dec 2005 11:36 GMT

Hi,

if you mean to find a recorded date, DataStamp, of a date more than 90 days
from now:

Datestamp <= Date() - 90

if you mean to find a dateOfPayment occurring more than 90 days after the
dateOfBilling:

DateOfBilling <= DateOfPayment -90

Hoping it may help,
Vanderghast, Access MVP

> Goodmorning,
>
> In my query I have a Bill date, I would like to know how I can have all
> bills < than 90 days as well as all bills > than 90 days
>
> Thanks!

Reply to this Message