calculate net business days ms access 97

[snoopy92211]

I need to get the following information in a report. I would like to calculate the number of business days between datereceived and datesubmitted for each . From then, I would like to sum the total date submitted. How can I do all this in a control source for a text box?

Here's the table that the report is based on:

Item Id DateReceived Datesubmitted
1 9/22/04 10/11/04
2 9/1/04 11/1/04
3 9/14/04 10/5/04
4 10/10/04 11/30/04


thanks!

 

[MichaelRed]

? "SUM" the date submitted? Distinctly weird.





MichaelRed

 

[snoopy92211]

Sorry... Ultimately what I'm trying to do is calculate the average number of days that the submitted items were outstanding.


does that make more sense?

 

[MichaelRed]

see faq181-261 for a way to calculate the number of business (work) days between dates.




MichaelRed

 

[snoopy92211]

Thanks!

How do I reference a module within a control source for a report?

sorry for all the newbie questions...