Data in query

H

halima

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!
 
H

halima

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!
 
M

Michel Walsh

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
 
Top