Hi All,

I am in middle of a development process and i am stuck. This is the situation:

I have three fields 1. StartTime, 2. EndTime, 3. TotalHrs. I can find the diffence using DateDiff('s',[StartTime],[EndTime]) in control source property in the TotalHrs. Fields StartTime and EndTime are bound to a table and TotalHrs is having this expression in the control source field. The value displays correctly in totalhrs. However, I am not able to store the TotalHrs value displayed in the underlying TotalHrs field in the Table.

I hope i have explained the situation. All i want is the value to be calculated in totalhrs and stored. I know a bit of VBA but not able to do this. I am using Access 2003 and VBA.

Any help would be greatly appreciated.

Thanks,

Deepak

Deepak,

You can use an Update query to update the Total Hours. But this isnt Excel, you cannot put a formula into a table.

What you can do though is store the parts of the formula in the table, ie: Start and End Date.

When you need the TotalHrs, evaluate the Start and End Time and you have the TotalHrs... but why store the result? You have no need to store it.

I hope you understand.

Lee

I agree, we were always taught in college calculated fields should not be stored, only queried

Thanks Lee. I appreciate your reply. I asked this doubt coz i tried this macro which i did using this microsoft article:


HOW TO: Use the ControlSource Property to Store Calculated Values in Access 2000

http://support.microsoft.com/kb/209172

Thank you for enlightning me on the UPDATE process.

Deepak