G
Guest
Access XP
My table contains fields: dept_number, allocation, and cost. Dept_number
contains a 2 digit department number, ie 11, 22, 44 etc. Allocation is a
descriptive name defining the % to allocate cost by departments.
The powers that be would like to have a report by SubAccount. SubAccount is
a new term. It is combination of the department number and a 4 character
code representing the Allocation.
Example:
Dept_number Allocation Subaccount
11 All dept met 11me05
11 Finance met 11me00
22 Adm BR 22br00
How can I use the 2 existing fields to relate to the new subaccount code. I
would like to have a report grouped by the new subaccount.
My table contains fields: dept_number, allocation, and cost. Dept_number
contains a 2 digit department number, ie 11, 22, 44 etc. Allocation is a
descriptive name defining the % to allocate cost by departments.
The powers that be would like to have a report by SubAccount. SubAccount is
a new term. It is combination of the department number and a 4 character
code representing the Allocation.
Example:
Dept_number Allocation Subaccount
11 All dept met 11me05
11 Finance met 11me00
22 Adm BR 22br00
How can I use the 2 existing fields to relate to the new subaccount code. I
would like to have a report grouped by the new subaccount.