I have below query inside the ms access, but this query counts all the days including the weekend but I only wanted to count the NUMBER of weekday (Monday to Friday). Please help
Number of Days Open: DateDiff('d',[dbo_Ticket]![date_opened],Date())
I tried to us the 'w' and 'ww' but it counts the number week not the number of days in a week.
Number of Days Open: DateDiff('w',[dbo_Ticket]![date_opened],Date())
Thanks!