!help!

Hi

I have an Access Table which contains 4 columns:
Id
Initials
Start Time
End Time

I am wanting it to also contain another column for the total time, which will be worked out by taking the [End Time] and subtracting the [Start Time]

I can perform this operation in a form but really require the table to hold this Total Time data.

Does anyone know how I can make this possible??

Thanx in advance!!!!

JB

You're going to have to add the column to your database and the best way is probably to do it through Access (you only have to do it once) in design view.

Then in your vb (assuming you're using recordsets)
rs!TotalTime = datediff("n",rs!starttime, rs!endtime) <--difference in minutes

you'll probably have to format your times/dates to get them to work (I don't know what format you are using.

Hi ,

I'm afraid a table as such can't contain fields which are an (arithmetical) result of others.

What you can do is to open a recordset and calculate whatever you want on the run.

Regards,
Shurik12.