Working days only query result

  • Thread starter Thread starter AlisonParsons
  • Start date Start date
A

AlisonParsons

I really am no expert on Access, so your help would be much appreciated
on this one! In my database I need to make a query to show the number
of days between two dates, but I need to only count the working days (ie
Monday to Friday) - could someone please help me with this one as I am
baffled. Many thanks, Alison :O)
 
Thanks for that. But, unfortunately I am a bit of a novice at actually
adding detailed coding. How do I enter this in a query?
 
If you've not done any coding I'll assume you have no modules in your mdb.

Click on the modules tab and create a new one. Copy the function I
referenced and paste it into this module. Save the module, ensuring you
don't give it the same name as the function.

In your query, in an empty column of the grid in the field cell put
Work_Days([MyFirstDate], [MySecondDate])
substituting your actual field names in the above.
 
I am now trying to add a calculated field in a query which will show the
date ten 'working days' after another date - how can I do this?
 
Back
Top