Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mckenziemh
- Order by date
-
Group by week days
Okay, I was wrong with the initial logic of the formula, but I've done a little research and found this solution. I've tested it, and it seems to work just fine. Access, unless otherwise defined, assumes that Sunday is the first day of the week. So, you can use the day assignments as follows...- mckenziemh
- Post #12
- Forum: Microsoft: Access Reports
-
Group by week days
I know this was from quite a while ago, but I thought I might give some insight to this problem. Depending on how big your existing table is already, I would recommend changing it a bit. It would be best to add a new record for each day the employee is off instead of a date range. Once you...- mckenziemh
- Post #10
- Forum: Microsoft: Access Reports
