This was great. Had the problem in Access 2007. Had a working Access query that I used in Excel 2007 to create a pivot table and chart, Excel seemed a little nicer with charts ;) Wanted to simulate the NetworkDay function so there would be less to do in Excel, so found some VBA. I don't know how...