qry to determine duration of meeting

[Nyd]

I have a database that keeps track of meeting. The table
is date, start time, end time, duration and notes. How
can I do it so that when a start and end time is entered
that the duration time will automatically fill in.

example

start time: 1:00 pm
end time : 2:30 pm
Duration : 2.5

 

[Andrew Smith]

You don't need the duration field in the table as the duration can be
calculated from the start and end times any time you need it. Instead,
create a query based on the table and add a calculated field -
Duration[End time] - [Start time])*24. (BTW I assume the duration in your
example should be 1.5 - if not then I'm missing something).

You can used the query any time you would use the table - eg as a the data
source for a form or report.