calculating days of the week

[Guest]

I have a date deposit and date received field. To calculate the number of
days it takes to deposit, I merely calculate Days: [dt deposit]-[dt
received]. However, I need to exclude Sat and Sun from being counted. I can
only count business days. I've tried Iff statements, but can't seem to get
it to work.

Can this be done?

 

[Douglas J. Steele]

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/

There are a couple of different approaches there.