Calculations in Queries

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

Guest

I have a database that holds employee records. I am also tracking their activity on an application used in the workplace. I have created a table to store this information using the fields ID, Month, Year, Activity. The activity is pulled manually from a report and the Month & Year are also entered manually. I have created a query that links the activty table to the personnel table with the intention of being able to calculate the amount of activity created by each department on a monthly basis as I know the department each user belongs to. So far all I have achieved is to be able to calculate a cummulative total for each person.
Any help you can provide is appreciated.
 
Hi Jim,
If a query result is sufficient, take the first query
(which sums for each person) and use it as the source for
a second query which will sum the individual sums for each
department. The department tag must be part of the first
query so you can use it to group on in the second query.
If you want a report using your existing query as a
source, use the department tag as a group outside the
personnel totals. Include a SUM() statement in the
department footer.

Hope this works for you.
-----Original Message-----
I have a database that holds employee records. I am also
Click to expand...
tracking their activity on an application used in the
workplace. I have created a table to store this
information using the fields ID, Month, Year, Activity.
The activity is pulled manually from a report and the
Month & Year are also entered manually. I have created a
query that links the activty table to the personnel table
with the intention of being able to calculate the amount
of activity created by each department on a monthly basis
as I know the department each user belongs to. So far all
I have achieved is to be able to calculate a cummulative
total for each person.
 
Back
Top