If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using expressions in a report to calculate pay
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 |
#2
|
|||
|
|||
Using expressions in a report to calculate pay
joseph.johnson4 wrote:
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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|