B
bd1031
I use Access to create forms for employees because I can import my data from
excel and create a report that links the data from my spreadsheet so that I
can print unique information for each employee. I am currently attempting a
total compensation statement to show employees how much of their compensation
is actually paid in the form of benefits. Generally, benefits statements
have pie charts to show the actual portion of the whole that is paid in
benefits vs. the monetary portion. I have been playing with charts in
Access, and cannot figure out how to create a pie chart based on two fields.
Is this even possible? If not, I have figured out bars charts, but I don't
want to have to enter their individual identifier each time I print the
report (we have over 3000 employees). I would consider using Word mail
merge, but I don't know if that would work either. Any advice would be
greatly appreciated!
excel and create a report that links the data from my spreadsheet so that I
can print unique information for each employee. I am currently attempting a
total compensation statement to show employees how much of their compensation
is actually paid in the form of benefits. Generally, benefits statements
have pie charts to show the actual portion of the whole that is paid in
benefits vs. the monetary portion. I have been playing with charts in
Access, and cannot figure out how to create a pie chart based on two fields.
Is this even possible? If not, I have figured out bars charts, but I don't
want to have to enter their individual identifier each time I print the
report (we have over 3000 employees). I would consider using Word mail
merge, but I don't know if that would work either. Any advice would be
greatly appreciated!