qry to determine duration of meeting

  • Thread starter Thread starter Nyd
  • Start date Start date
N

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
 
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.
 
Back
Top