marseneault
Registered User.
- Local time
- Today, 19:19
- Joined
- Jan 11, 2019
- Messages
- 24
So this seams to be an easy request, but I can't figure out how to word it.
My boss is doing Performance Evaluations for everyone and wanted to Cross Reference Each Contractor with the Job That they worked on. The only way I know for sure is by checking to see if they have a time clock record.
I am looking for the right syntax string to basically Give this result:
If Contractor Has TimeClock Record, Show ProjectName, ProjectSalesTotal and ProjectSalesProfit.
The Syntax that I did use Listed all the TimeClock Records, so if the person worked 5 times on a job, it would list the Project Name, SalesTotal and Profit 5 times instead of one.
My boss is doing Performance Evaluations for everyone and wanted to Cross Reference Each Contractor with the Job That they worked on. The only way I know for sure is by checking to see if they have a time clock record.
I am looking for the right syntax string to basically Give this result:
If Contractor Has TimeClock Record, Show ProjectName, ProjectSalesTotal and ProjectSalesProfit.
The Syntax that I did use Listed all the TimeClock Records, so if the person worked 5 times on a job, it would list the Project Name, SalesTotal and Profit 5 times instead of one.