Calculating between two working days in a form.

[scgoodman]

I have three data fields in my form. Shipped Date, Delivered Date and Turn Around Time.
I need to calculate the Shipped Date and Delivered Date and populate it in the TAT field.

 

[John Big Booty]

In the Control Source for TAT put

=DeliveredDate-ShippedDate

The TAT should be a calculated field and should not be stored in your table, as it can be calculated whenever it is required from the other two fields.

 

[John Big Booty]

In the Control Source for TAT put

=[DeliveredDate]-[ShippedDate]

The TAT should be a calculated field and should not be stored in your table, as it can be calculated whenever it is required from the other two fields.

 

[John Big Booty]

Sorry about the double post don't quite know haw that happened.