If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Data in a query
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
From several workbooks onto one excel worksheet | steve | General Discussion | 6 | December 1st, 2005 08:03 AM |
AHHHH-Get Data from Multiple Excel workbooks | JAA149 | General Discussion | 5 | October 30th, 2005 05:19 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |