filtering weekends in query

[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

 

[Tom Wickerath]

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