Run a query or report with calculations in it?

[Guest]

Is it possible to run a query or report that runs formulas from data in a
table/form and turns them into totaled numbers in that query or report?

Query/Report takes data from fields a record and tell me for a given set of
records that:
i.e. Employee Smith works 28 hours per week at 13.11 per hour for a total of
367.08 (weekly column) total of 1589.46 per month; plus a payroll burden of
16.2% = 257.49, plus admin burden of 22.8% = 362.40
then do that also for employees Jones, Brown, Smart and Efficient and give
totals at the bottom??

I have a table with the hourly rates and the number of weekly hours set up.
Where would I need to put the percentage burdens to have it all calculate
out??

Thanks so much!!!!!
Thanks!!!

 

[Guest]

Cheryl,

You can put formulas in a query, but to get totals at the bottom you really
need a Report based on a query.

To put formulas in a query, enter somthing like this in a query field:
Weekly Total: [Hours]*[Rate]
where Hours and Rate are fields in your table. A colon must follow the name
you want the query field to be ("Weekly Total" in this case). The field
names must be enclosed in square brackets.

You could then create a Report that Sum'd the 'Weekly Total' field of the
query.