Find Work Days

[Dgavilanes]

If I type a Date From Monday to Friday I get
the right number of working days.
if I type Sunday Date to Saturday Date I would like it to = 5 full working days
any ideas
thank you
Dennis

 

[David R]

Look up the Access help file on 'networkdays'. It should help you with what you want. There are also topics on it in the archives of this forum, behind the search button.

 

[Dgavilanes]

Thanks so much for responding David R.
I follow your e-mail I just don't know What I did Wrong the query will not even open
I have two fields in the tbl_Dates
StartDate
EndDate
Query
I placed both fields inside the query plus
([StartDate],[EndDate])
saved and the query will not open, I do some Data in the table 03/24/02, 03/30/02
maybe I missed something
thanks
Dennis

 

[David R]

Your calculated field should look much like this: in a new, blank field, type in

NetDays: NetWorkdays([StartDate],[EndDate])

Provided your fields are actually date/time type fields, this should work.