Expression Buider

[jrsarrat]

Hi there!

On an Access report, I'd like to add the total hours worked based on 4 fields that produce the following times: 1. initial daily log in, 2. log out for lunch, 3. back in from lunch, and 4. End of Day logout.

Can I use the Expression Builder (Design View>Property Sheet>Data tab>Control Source) directly from the report to provide me with each employee's total hours worked? Or, do I need to create another query?

The textbox on my report is currently unbound.

Your help is much appreciated!

Sincerely,

J.

 

[Joe4]

Please post some sample data and expected results so we can get a better understanding of your data structure.

 

[jrsarrat]

Please post some sample data and expected results so we can get a better understanding of your data structure.

Strangely enough, I don't see where I can attach a doc.?

 

[Joe4]

You cannot attach files, but you can post images using some tools mentioned in section B here: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

However, I find that you can usually Copy and Paste data from a Table or Query simply by using Copy & Paste.
Here is an example of me doing it below:

1	1/15/2010	1/15/2016
2	1/15/2010	1/15/2018
3	1/1/2010	4/1/2016
4	1/1/2010
5		1/1/2016
6	2/28/2004	2/28/2010

<tbody>
[TH="bgcolor: #c0c0c0"] ID [/TH]
[TH="bgcolor: #c0c0c0"] date1column [/TH]
[TH="bgcolor: #c0c0c0"] date2column [/TH]

</tbody>

 

[jrsarrat]

You cannot attach files, but you can post images using some tools mentioned in section B here: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

However, I find that you can usually Copy and Paste data from a Table or Query simply by using Copy & Paste.
Here is an example of me doing it below:

1	1/15/2010	1/15/2016
2	1/15/2010	1/15/2018
3	1/1/2010	4/1/2016
4	1/1/2010
5		1/1/2016
6	2/28/2004	2/28/2010

<tbody>
[TH="bgcolor: #C0C0C0"] ID
[/TH]
[TH="bgcolor: #C0C0C0"] date1column
[/TH]
[TH="bgcolor: #C0C0C0"] date2column
[/TH]

</tbody>

Thank you, Joe4!

Table:

1	2:01:31 PM				8/20/2018
10	2:24:59 PM	2:25:24 PM	2:26:03 PM	2:26:44 PM	8/20/2018

<caption> tblLogInOut </caption><thead>
[TH="bgcolor: #c0c0c0"] PF_ID [/TH]
[TH="bgcolor: #c0c0c0"] Log_In [/TH]
[TH="bgcolor: #c0c0c0"] Lunch_Out [/TH]
[TH="bgcolor: #c0c0c0"] Lunch_BackIn [/TH]
[TH="bgcolor: #c0c0c0"] LogOut_EOD [/TH]
[TH="bgcolor: #c0c0c0"] Dte [/TH]

</thead><tbody>
</tbody><tfoot></tfoot>

 

[jrsarrat]

What information would you like from the report?

 

[Joe4]

So, in the first record of your example where there is no log-out time, what should be returned for that?
Do you have any records which would span two days? How do you show/account for that?