Working days only query result

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)
 
A

AlisonParsons

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?
 
J

Joan Wild

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.
 
A

AlisonParsons

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?
 
Top