B
Bill
"Gods of Access",
I have a form (frm_CallDisplay) which auto refreshs every 10 seconds look
for new data. In this display (displayed in table format) I want a column
that shows the time elapsed from the start time to present.
Basically I want a separate column that calculates the difference from the
field (dtimed) to =Now(). Since this form refreshs automatically it should
update with the refresh. I would also like to be able to format this column
to display by minutes first, then hours and minutes until it hits 24 hours
then switch to elapsed days (1 day, 2 days, 3 days, etc).
Thanks for your guidance.
Bill
I have a form (frm_CallDisplay) which auto refreshs every 10 seconds look
for new data. In this display (displayed in table format) I want a column
that shows the time elapsed from the start time to present.
Basically I want a separate column that calculates the difference from the
field (dtimed) to =Now(). Since this form refreshs automatically it should
update with the refresh. I would also like to be able to format this column
to display by minutes first, then hours and minutes until it hits 24 hours
then switch to elapsed days (1 day, 2 days, 3 days, etc).
Thanks for your guidance.
Bill