I am sorry... I forgot to include the file structure and everything.
All pertinent date fields are in one table "Data Collection". The pertinent date fields names are [CAR Discovered Date] and [CAR TO EVMC Date (initial)]
The holiday table is titled Holidays
The query holiday table is titled qryHolidays
So based on the formula you gave me.
I am comfortable with design view...
Scholar81
Last Activity: Oct 13 '09, 11:01 PM
Joined: Oct 13 '09
Location:
-
Scholar81 replied to Date formula to count days between two dates but not count holidays or weekendsin AccessThank you so much cuz, I love my hair ;-)
In Access 2007:
I already set up a holiday table with all holidays from 2007 to 2012. however, I use data/time field for all holiday dates so should I change it to text field? Also, I looked at the relationship and there's no connection to any forms, queries or forms. It's empty.
I know the next step is to create a holiday query but after that I am completely lost...Leave a comment:
-
Scholar81 started a topic Date formula to count days between two dates but not count holidays or weekendsin AccessDate formula to count days between two dates but not count holidays or weekends
Hello,
I am a novice Access developer and my boss asked me to build a database and I said yes. Now I realized the bite is way too big and I'm trying not to choke ;-)
And what's worse, he does not want me to use VBA (thank god, one less thing for me to tear my hair out about). So I am struggling to figure out how to do this:
Count the number of days between two dates and not count holidays and weekends.
...
No activity results to display
Leave a comment: