Good day everyone… Is there anyone who could help me create a BAQ for labor hrs. on all jobs with in specific dates. I am not familiar enough with BAQ’s to do this on my own. please and thank you
Here’s how I would do it. There are likely other solutions as well, so others feel free to chime in!
The table where labor is recorded is the LaborDtl table. To find all Labor transactions within a date range, set up Criteria on the table for the PayrollDate field… one criteria for PayrollDate >= the beginning of the range, and another criteria for PayrollDate <= the end of the date range. The fields you want to display are at least the PayrollDate, EmpID, and LaborHrs… but any others that strike your fancy are fair game. If you need additional fields that aren’t in the LaborDtl table (for example, the employee name), you can add additional tables and link them… but that might be another discussion.
1 Like