I have a report based on a query I created. The query produces the five following items:
PROJECT NUMBER
DATE
WORK CODE
BILLABLE HOURS
EMPLOYEE
The Query prompts the user for PROJECT NUMBER.
I created a Report based on the query that shows the project grouped
by WORK CODE. This report works great and produces the sum for Each
Group.
WHAT I NEED NOW is to create a new SUM based upon work codes in
the report footer. For example:
Lets says we have the followng WORK CODES:
WELDING
ASSEMBLY
TEST
REWORK
QC
RESEARCH
TRAVEL
The main report would create SUMS for each group by WORK CODE and that is working fine. But we need to know our total ENGINEERING on the
project and this equals All WELDING + ALL ASSEMBLY (ENG = WELDING + ASSEMBLY) for the project. We need to know total SUPPORT = RESEARCH + TRAVEL.
I want to be able to add fields at the REPORT footer that will show me the TOTAL BILLABLE HOURS for each of these.
I am not sure how to construct this expression in ACcESS.
I basically need to say something like ENG = Sum of all Records where
WORK CODE is equal to WELDING or ASSEMBLY.
and for SUPPORT that same idea: SUPPORT = Sum of all records where WORK CODE is equal to RESEARCH or TRAVEL.
Does anyone know how I can add these to the footer of the report and what the expressions would look like.
Thanks