I've been playing with Oracle and SQL Server now for a year or so and getting on fine, howvere someone asked me to do somehting in Microsoft Access for them, and i must say i'm stumped! as i can't seem to achieve what i would like.

I have a table, with a start date/time column, and a finsih date/time column.

I also have another column which needs to represent the number of hours between the start and the end, now i would have usually done this using a trigger, or somehting to work it out, but how do i do it in MS Access?! or how do i place a trigger on the table to do lots of work for me?1

cheers andy