Using expressions in a report to calculate pay

  • Thread starter joseph.johnson4
  • Start date
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
 
M

Marshall Barton

joseph.johnson4 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top