Data in a query

Goodmorning,

In my query I have a bill date and I would like te make a filter to have a
view on all billsthan 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

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));

--
Brendan Reynolds


"halima" wrote in message
...
Goodmorning,

In my query I have a bill date and I would like te make a filter to have a
view on all billsthan 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