N
nydia
i have a report that keeps track of when clients come to a
meeting and how long the meeting is. i have a qry that
has clients name, date of meeting, start time, end time
and i put an expression that will show me the duration of
the meeting ([starttime]-[endtime]*24),
now i created a report based on this query, what i want a
total hours in meeting, i want this to add up all the
duration times.
example
John Smith
1/1/04 1:00-2:00 1hour
1/2/04 2:00-3:30 1.5hour
Duration total: 2.5
how can i do this???
meeting and how long the meeting is. i have a qry that
has clients name, date of meeting, start time, end time
and i put an expression that will show me the duration of
the meeting ([starttime]-[endtime]*24),
now i created a report based on this query, what i want a
total hours in meeting, i want this to add up all the
duration times.
example
John Smith
1/1/04 1:00-2:00 1hour
1/2/04 2:00-3:30 1.5hour
Duration total: 2.5
how can i do this???