Database has tables with:
employee data (date, hours, ID#, location, equip ID, etc)
vehicle data (equip ID, rate/hr, etc)
personnel data (name, payrate)
materials (location, # of items used, crew, etc)
barricades (billings for barricades used at locations)
My problem is producing a monthly report in a spreadsheet format with totals for hours, employee pay, vehicle hours, vehicle costs, material costs, and barricade costs--totaled across by activity with averages for costs and hours, and totaled down for hours and costs.
I'll attach the report as a text file.
The query to get the totals includes queries with the employee, vehicle, material, and barricade costs all sorted by activity code but for it drops all activities that don't have costs in each column--if there weren't any costs entered for material or barricades for the month, they get dropped.
How do I get everything even with some fields are null?
employee data (date, hours, ID#, location, equip ID, etc)
vehicle data (equip ID, rate/hr, etc)
personnel data (name, payrate)
materials (location, # of items used, crew, etc)
barricades (billings for barricades used at locations)
My problem is producing a monthly report in a spreadsheet format with totals for hours, employee pay, vehicle hours, vehicle costs, material costs, and barricade costs--totaled across by activity with averages for costs and hours, and totaled down for hours and costs.
I'll attach the report as a text file.
The query to get the totals includes queries with the employee, vehicle, material, and barricade costs all sorted by activity code but for it drops all activities that don't have costs in each column--if there weren't any costs entered for material or barricades for the month, they get dropped.
How do I get everything even with some fields are null?