Data in a query

[Guest]

Goodmorning,

In my query I have a bill date and I would like te make a filter to have a
view on all bills>than 90days as well as all bills< 90 days.

Maybe you will get this mail twice, put I am not familiar with the
communication group.

Many Thanks,

Halima

 

[Brendan Reynolds]

This example uses the Orders table from the Northwind database. Replace
references to 'Orders' with your table name, and to 'OrderDate' with your
date field name.

See 'Abs Function', 'DateDiff Function' and 'Date Function' in the help file
for more information.

SELECT Orders.*
FROM Orders
WHERE (((Abs(DateDiff("d",[OrderDate],Date())))>=90));