filtering weekends in query

  • Thread starter Thread starter bozdog
  • Start date Start date
B

bozdog

Hi
I am currently running an access database application, built in access
2000, and would like to filter a query which will exclude saturdays and
sundays from an existing date field. Any help appreciated.
Thanks in advance
 
The following example works in the sample Northwind database. You may need to first reset
a few order dates to a weekend, so that you can see that they will be filtered out. Copy
the SQL statement into a new query in Northwind and run it.

SELECT Customers.CompanyName, Orders.OrderDate,
WeekdayName(Weekday([OrderDate])) AS OrderDayName
FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (((Weekday([OrderDate])) Not In (1,7)))
ORDER BY Orders.OrderDate;

Tom
__________________________________________


Hi
I am currently running an access database application, built in access
2000, and would like to filter a query which will exclude saturdays and
sundays from an existing date field. Any help appreciated.
Thanks in advance
 
Back
Top