Data in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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