Get time elapsed and number of instances

[CaliburBlade138]

Hello,



I am a little lost on this and I need some help. I created a simple access database to scan users in and out with a time stamp and some other information as seen in my attached image. I use SQL to read and write to the database, but I need a query or vba function or something to get the entire instance of a persons name, date range with elapsed time between scans, and how many times scanned START and STOPPED.

For example, if I have something like

3/15/2022 8:30AM John Smith
3/15/2022 9:00AM John Smith

I would like to get the time elapsed from the table, the number of occurrences for start and stopped, and put it in a report or a chart? I'm lost...

Attachment 47440

[ranman256]

a Date field can hold both Time and Date, there's no need for 2 fields.

using VB, you will need to cycle thru the records 1 by 1. (make sure they are sorted correctly)
get the start,
next rec
get the Finish
calc elapsed time in minutes: DateDiff("m",vDateStart, vDateEnd)
post result to a table.

[CaliburBlade138]

ranman256,

Is it still possible to get elapsed time with two different columns with date/time? and if so how? I'm lost and it's out of my scope of practice...

[Gicu]

Combine your two fields into one in a query then use ranman's suggestion. With questions like this it is always best to create a small db sample with some "dummy" data to illustrate your issue as it helps to see it when providing an answer. Somebody needs to create that and you are in the best position to do it .

Cheers,

[CaliburBlade138]

Thanks, working on it now!