Results of past 7 days

[Forrest]

I have a form in which the user inputs crane inspection results (a series of check boxes). When the user clicks the save button, I would like to run a query (I guess a query is how to do this) that searches records for the past seven days (less weekends and holidays) and alerts the user to days that inspection results were not entered for that particular crane (cboCrane.Value) and that particular shift (cboShift.Value) via a message box.

How do I get it to only look at records for the past 7 days (less weekends and holidays)?

Any help will be greatly appreciated.

 

[KeithG]

You can use the datediff function and weekdays function to calculate 7 days back. The Holidays are what is going to cause you trouble. You will probably have to write a custom VBA function.

 

[Forrest]

KeithG, Thanks for the suggestion. I kinda sorta know how to use DateDiff and Weekdays by themselves. How do I use them together to count back 7 days?