G
Guest
In Access 2003, I'm trying to build a calculated field in a report based on
two unrelated tables. For example, in tblEmployees, the fields include
FirstName, LastName, Dept. and Salary. In tblAssumptions (which stores tax
rates that are modified periodically), I have fields for Name and Percentage.
Entries in this table are as follows:
NAME PERCENTAGE
Federal .08
State .05
Social Security .062
Medicare .0145
(The purpose of the Assumptions table is to allow our Accounting department
the ability to forecast budgets based on changing tax rate scenarios. They
want to be able to open an Assumptions form, change any tax rate as desired,
then re-run the report based on the updated assumptions.)
In the report, which will be grouped by Dept., I would like to list each
employee and their salary. Along side that, I will have columns for each of
the taxes, with each tax rate multiplied by the salary. I'm familiar with
creating calculated fields, but I'm struggling with the correct syntax for
multiplying the salary by the appropriate tax rates. I do have familiarity
with VBA if that's necessary, so if anyone can point me in the right
direction, it would be much appreciated!
two unrelated tables. For example, in tblEmployees, the fields include
FirstName, LastName, Dept. and Salary. In tblAssumptions (which stores tax
rates that are modified periodically), I have fields for Name and Percentage.
Entries in this table are as follows:
NAME PERCENTAGE
Federal .08
State .05
Social Security .062
Medicare .0145
(The purpose of the Assumptions table is to allow our Accounting department
the ability to forecast budgets based on changing tax rate scenarios. They
want to be able to open an Assumptions form, change any tax rate as desired,
then re-run the report based on the updated assumptions.)
In the report, which will be grouped by Dept., I would like to list each
employee and their salary. Along side that, I will have columns for each of
the taxes, with each tax rate multiplied by the salary. I'm familiar with
creating calculated fields, but I'm struggling with the correct syntax for
multiplying the salary by the appropriate tax rates. I do have familiarity
with VBA if that's necessary, so if anyone can point me in the right
direction, it would be much appreciated!