D
DbLoc
Trying to create a report that will allow an organizational listing be
outuput in cleartext form (excel). The basic table consists of the total
organizational codes along with partial codes. such as
1.0 Group Name
1.1. Dept Name
1.1.1. Division Nam
1.1.1.1 Branch Name
1.1 Same Group Name
1.1. Same Dept Name
1.1.2. Different Branch Name
2.0 Different Group Name
2.1 Differnt Dept Name
Etc.
We have many many different codes that come under various groups
(1,2,3,4,5..) within each group the codes expand out to upto 7 characters
with each character representing a different level in the organization. I'm
trying to output a report in excel format that will repeat the cleartext for
each level depending on which code is input. If I input 1.1.1, I want it
to read Group/Dept/Div each on their own line and if I input 1.1.1.1.2 to
repeat the Group/Dept/Div/show new Branch and show new section. I was trying
to create a form that would pull up the cleartext depending on what part of
the code I input to allow me to make changes where needed and to output only
specific codes (some changed and some the same as what is already in the
table)
Is this possible in access in a fairly non complex way? I'm not too
familiar with much more than basic coding in acccess
outuput in cleartext form (excel). The basic table consists of the total
organizational codes along with partial codes. such as
1.0 Group Name
1.1. Dept Name
1.1.1. Division Nam
1.1.1.1 Branch Name
1.1 Same Group Name
1.1. Same Dept Name
1.1.2. Different Branch Name
2.0 Different Group Name
2.1 Differnt Dept Name
Etc.
We have many many different codes that come under various groups
(1,2,3,4,5..) within each group the codes expand out to upto 7 characters
with each character representing a different level in the organization. I'm
trying to output a report in excel format that will repeat the cleartext for
each level depending on which code is input. If I input 1.1.1, I want it
to read Group/Dept/Div each on their own line and if I input 1.1.1.1.2 to
repeat the Group/Dept/Div/show new Branch and show new section. I was trying
to create a form that would pull up the cleartext depending on what part of
the code I input to allow me to make changes where needed and to output only
specific codes (some changed and some the same as what is already in the
table)
Is this possible in access in a fairly non complex way? I'm not too
familiar with much more than basic coding in acccess