Expression for current week

[Yasmin Nora]

Would like to know the expression to use in an Access
query to run a weekly report that will display data for
only the 5 business days of the current week. Thanks

 

[PC Datasheet]

Not all weeks have 5 business days! You have to build a table of holidays and
include that table in you expression to exclude any holidays that fall in the
current week.

 

[John Vinson]

Would like to know the expression to use in an Access
query to run a weekly report that will display data for
only the 5 business days of the current week. Thanks

Bearing in mind PC Datasheet's cogent suggestion about holidays,
here's an expression that returns the range from the most recent
Monday to the next Friday:

= DateAdd("d", 1 - DatePart("w", Date(), vbMonday), Date())

AND <= DateAdd("d", 5 - DatePart("w", Date(), vbMonday), Date())

If the query is run on a weekend it will return the previous week.