Using calculations in ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table showing employee name, type of insurance coverage, monthly amount insurance, annual amount and FICA tax. I need to cacluate annual amount (monthly amount *12) and FICA tax (annual amount *0.765. I can figure out how to do these calculations. However, how do I also get a total for each column? I know how to do this in Excel but not sure how to do this in ACCESS. Help please.
 
Access queries are not spreadsheets, so you cannot get columnar totals in
your query. Make your query the record source for a report; use the Report
Wizard to create your report and, depending on the format you select, the
Wizard will create column totals for you.

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Diana said:
I have a table showing employee name, type of insurance coverage, monthly
Click to expand...
amount insurance, annual amount and FICA tax. I need to cacluate annual
amount (monthly amount *12) and FICA tax (annual amount *0.765. I can
figure out how to do these calculations. However, how do I also get a total
for each column? I know how to do this in Excel but not sure how to do this
in ACCESS. Help please.
 
Back
Top