Formula to work out the turn around time

[Riaang]

Hi all,

I have 2 dates
1) Received date
2) Capture date

In another column I want a formula that will work out the turn around time between the dates.

Eg. Received date Capture Date Turn around
12/06/2003 12/06/2003 1 day
12/06/2003 14/06/2003 3 days
13/06/2003 14/06/2003 2 days

etc.

I am still new to access so please give clear instructions.

Thanks a lot

 

[LTunnicliffe]

Try this:

TurnAround: [ReceivedDate]-[CaptureDate]+1

Hope this helps!

 

[Riaang]

Hi,

Thanks for this. It seems to work just fine.

One problem is that it doesn't update the value on the main table.

Any suggestions

Regards

 

[LTunnicliffe]

I think what you are going to have to do is make an update query to update the value of that field in you original table. You have to make sure that the TurnAround field is in your table first.

Make sesne?