Regards to all!
In advance I would like to apologize for my English.
My doubt is if is possible to do the next example em access and if yes, how?
I have a query with the following fields:
ID:auto number
stand_code: text
times: date/hour
order of completion:date/hour format as number
my query is something like this:
ID order_of_completion stand_code times
1 730 cbse 0:59:44
2 735 clsr 3:52:24
3 735 hbse 1:06:48
4 940 clse 1:53:52
5 1010 hlse 4:43:12
and what i would like to do is this:
times beginning of task end task
0:59:44 7:00:00 7:59:44
3:52:24 7:00:00 10:52:24
1:06:48 7:59:44 9:06:32
1:53:52 9:06:32 11:00:24
4:43:12 10:52:24 15:35:36
there are two equals beginnings because there are two people working at the same time.
the order_of_completion must be respect
thanks to all
In advance I would like to apologize for my English.
My doubt is if is possible to do the next example em access and if yes, how?
I have a query with the following fields:
ID:auto number
stand_code: text
times: date/hour
order of completion:date/hour format as number
my query is something like this:
ID order_of_completion stand_code times
1 730 cbse 0:59:44
2 735 clsr 3:52:24
3 735 hbse 1:06:48
4 940 clse 1:53:52
5 1010 hlse 4:43:12
and what i would like to do is this:
times beginning of task end task
0:59:44 7:00:00 7:59:44
3:52:24 7:00:00 10:52:24
1:06:48 7:59:44 9:06:32
1:53:52 9:06:32 11:00:24
4:43:12 10:52:24 15:35:36
there are two equals beginnings because there are two people working at the same time.
the order_of_completion must be respect
thanks to all