Table datasheet vs form datasheet question/issue

[rck3]

Ok so I know there is something basic I must be missing. I have a database all complete except for 1 minor bug I can not work out. I have a database with with a table Employee_Time and a form for import. I have 1 field which is a time calcuation from the start/stop time in 2 other fields. When I fill the form out, that time in hours displays correctly. When I exit and return to the form in datasheet view I can see all of the hours stored but if I open the actual Employee_Time table that time is not stored. How can it store in the form view but not on the actual table?

[Bob Fitz]

I have 1 field which is a time calcuation from the start/stop time in 2 other fields

I assume that the "2 other fields" are start and finsh times and that the calculation that is diplayed in the form is the difference between the start and finish times. If that is correct, then the start and finish time should be stored in the table, but the calculated time btween them should NOT be stored. It should be calculated whenever and wherever it is required.

[rck3]

Ok, I was going to do that but in the reporting I was running into the issue of hours being calculated and not allowing a sum, just a count.

[rck3]

I am using =DateDiff("h",[Start Time],[Stop Time]) & ":" & Format(DateDiff("n",[Start Time],[Stop Time]) Mod 60,"00") which gives me the time in the format I want but is there another way to do this so I can sum the hours on my report?

[rck3]

figured it out, you can close this