Calculating time taken on tasks help!

[stevembe]

Hi. I have compiled an access database (office xp) and two of the fields are start date for a task and end date of a task. I have been asked to set up a field that calculates how much time has elapsed since the task began and once complete how long it actually took from beginning to end. Can anyone help me in this unnecessary pressure I have been placed under on the verge of Xmas. Many many thanks in advance.

 

[maxmangion]

Search this forum for Calculate Time, there are several threads covering this topic.

 

[stevembe]

More to this

I need the field in my table so I can place it on a form. How do I make this calculation in the table.

 

[maxmangion]

I need the field in my table so I can place it on a form. How do I make this calculation in the table.

it is not wise to store your calculated field in a table, use queries instead.

 

[stevembe]

Firstly many many thanks for your replies. The problem is I am access challenged. The form, based on a table exists. Using the search you kindly recommended earlier I have now developed a query that works but how do i get the results for each record to show on the form?

 

[robthedog]

Maybe the simplest way to do this is to build a query including the start and end date fields, then just subtract the start date from the end date to give you the number of days: Enter the following in the field row to the right of your dates.

NoOfDays: [End_Ord_date]-[Start_Ord_Date]​

Cheers

 

[stevembe]

Thanks robthedog,

see me last bit though, any ideas on getting the query to display on the form for each record. At the moment my query works but just displays a list of all records with the days elapsed next to it? Cheers

Steve

 

[maxmangion]

ideally you should bound your form to your query (which you should have created i.e. the query which includes your calculated field). in fact it is not wise to directly bind your form to a table, but you should bound forms to queries.

 

[robthedog]

Add a text box to your form, then in the ControlSource property enter:

=[End_ord_date]-[Start_Ord_Date]

(Obviously use your field names!!)

This should display the no of days elapsed...

 

[stevembe]

Dear rob and max,

my form is now fully functional and the number of days is showing beautifully! Thanks for your help, the frustration has now disappeared! Have a wonderful christmas and all the best for the new year
Steve

 

[maxmangion]

i'm glad to hear that you've sorted out your problem

Have a nice Christmas you too !

 

[robthedog]

Chill out now for Xmas....