Search results for query: *

Hi Again, Golom I just want to say thank you for your help. I wouldn't have ever figured it on my own. PHV Thanks for the links.

Scratch the last question - I answered it. But now I am having another problem. The code is working but know I am trying to create a form so that when the data is entered it would calculate the labor like it suppose to. How do I set up my form so that new records can be added. Right know it's...

Hi Golom, I copied and pasted the code and it worked! I have a question though - in the code am I supposed to include the OR statement or use one or the other? I removed the statement before the OR.

I tried using the code above and I keep getting an error - stating that it is in the from statement and "As" in the second line before the T is highlighted. I am not that familar with code to troubleshoot this. Any assistance would be greatly appreciated.

That's correct and I that is what I was trying to accomplish in my IF statement. Thanks so much Golom.

Thanks guys. I will take a stab at it again.

Thanks fneily. This helps a lot but I have a question. If I reference the PayHistoryID in the Daily Tracking table does that mean that each time I enter a record I have to type in the appropriate PayHistoryID for that record or is there a way to automate this process?

I am desperately trying to calculate total labor for employees in one table based on their rate of pay during the time period worked. I have a table that has the date of trip, and number of hours. I have another table that has the employee pay history which is the rate date and the new rate of...

I am desperately trying to calculate total labor for employees in one table based on their rate of pay during the time period worked. I have a table that has the date of trip, and number of hours. I have another table that has the employee pay history which is the rate date and the new rate of...