Calculated values insertion into report based on a criteria

  • Thread starter Thread starter SGangs
  • Start date Start date
S

SGangs

Hi!!
I'm maintaining a database wherein i need to capture the date and time in
realtime for each record. So after taking in the suggestions from this forum,
i have inserted a calculated unbound field in my form to display the time
lapsed as of now and for all closed items, i'm storing the closure time in a
field.
Now the problem i'm facing is in the reports.
I need to display the total time for each client where the transactions are
open as on the report date.(realtime) and the closed items as a difference of
2 fields (Transaction closed time - Transaction opened time).
I need to display all the records in a report groupwise (open and close)
and a summary of time lapsed. How can i do this in Access reports. I'm using
MSAccess 2003.
Please help.
 
SGangs said:
I'm maintaining a database wherein i need to capture the date and time in
realtime for each record. So after taking in the suggestions from this forum,
i have inserted a calculated unbound field in my form to display the time
lapsed as of now and for all closed items, i'm storing the closure time in a
field.
Now the problem i'm facing is in the reports.
I need to display the total time for each client where the transactions are
open as on the report date.(realtime) and the closed items as a difference of
2 fields (Transaction closed time - Transaction opened time).
I need to display all the records in a report groupwise (open and close)
and a summary of time lapsed. How can i do this in Access reports. I'm using
MSAccess 2003.
Click to expand...


In your calculation for the elapsed time, try using
Nz([closed time], Now()) instead of just [closed time]
 
Back
Top