access query - continued

I sent message before I finished explaining my problem!



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?

Are you trying to create a cross tab report? Those are often difficult for just that reason, if you have null values. I've read several articles on it, but not recently. I'd suggest googling for "access cross tab report".