using data in 2 fields of a table to link to new field

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Sue said:
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.
Click to expand...

It looks to me like you may want to add the subaccount field to your
table.

Otherwise: how consistent are the names in the Allocation field? Is the
third and forth character in the subaccount field always equal the first two
characters after the first space in the Allocation field? How are the last
two characters in the subaccount field determined? Have you considered the
problems of sorting numbers in a text field e.g. 01 and 11?
 
Joseph Meehan said:
It looks to me like you may want to add the subaccount field to your
table.

Otherwise: how consistent are the names in the Allocation field? Is the
third and forth character in the subaccount field always equal the first two
characters after the first space in the Allocation field? How are the last
two characters in the subaccount field determined? Have you considered the
problems of sorting numbers in a text field e.g. 01 and 11?
Click to expand...
 
Back
Top