Using expressions in a report to calculate pay

[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

 

[Marshall Barton]

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.

Are you sure you want both Expr1 and pay to be divided by
60?

As for your question about things not showing in the report,
you should explain what you want to see in the report and
what you did to try to display it along with a Copy/Paste of
the report's record source query.