B
bob1
I want to create a query that shows elapsed time from the previous record and
I'm having a lot of difficulties....
The fields I have are
User ID, Case#, Units, Location, Date/Time
I want to enter a start and end date range (MM/DD/YY HH:MM:SS AM/PM) then
enter the a User ID and have the query pull of all the activities between the
time range. I already have this query but I want to add elapsed time to the
query to show the amount of time elapse from previous record.
The reason I am making a query based on a query is that that the original
query has many many criteria to get the information that I need. Also the
table shows the Date/Time in one field. So basically the results that I need
are.
User ID, Case #, Units, Location, Date/Time, Elapsed Time.
Thank you for your help!!
I'm having a lot of difficulties....
The fields I have are
User ID, Case#, Units, Location, Date/Time
I want to enter a start and end date range (MM/DD/YY HH:MM:SS AM/PM) then
enter the a User ID and have the query pull of all the activities between the
time range. I already have this query but I want to add elapsed time to the
query to show the amount of time elapse from previous record.
The reason I am making a query based on a query is that that the original
query has many many criteria to get the information that I need. Also the
table shows the Date/Time in one field. So basically the results that I need
are.
User ID, Case #, Units, Location, Date/Time, Elapsed Time.
Thank you for your help!!