J
joseph.johnson4
I have created a report utilizing data from a query and a table that shows
how many hours worked each day utilizing the expression:
Expr1: Sum(DateDiff("n",[Schedule]![TimeIn],[Schedule]![TimeOut])/60)
With that expression it gives me the answers that I need in the query.
However, when I put it into a report it does not show any of the data from
the schedule table that I utilized to create my timeclock.
The other problem that I am encountering is that I am trying to calculate
pay utilizing the expression:
[Expr1]*[Hourly Wage]/60
When I create this expression in the Expression Builder on either a report
or query it just shows up blank. I believe that the expressions are correct.
However, I am getting a little frustrated with trying to figure out why it is
not working like it should and definitely could utilize some help.
Thank you, Joe
how many hours worked each day utilizing the expression:
Expr1: Sum(DateDiff("n",[Schedule]![TimeIn],[Schedule]![TimeOut])/60)
With that expression it gives me the answers that I need in the query.
However, when I put it into a report it does not show any of the data from
the schedule table that I utilized to create my timeclock.
The other problem that I am encountering is that I am trying to calculate
pay utilizing the expression:
[Expr1]*[Hourly Wage]/60
When I create this expression in the Expression Builder on either a report
or query it just shows up blank. I believe that the expressions are correct.
However, I am getting a little frustrated with trying to figure out why it is
not working like it should and definitely could utilize some help.
Thank you, Joe