How to Calculate Total?

[2 Advanced]

Hi, i'm trying to calculate the amount of employee for each company giving me a total in the queries.. how do i go about this? I'm not an person who uses Access to solve this.

I have amount 20 Companies stored and over 800's employee..

Here are the field in the table:

EmployeeID
EmployeeName
NumberofEmployee

Thanks! Hope this helps.

 

[lightray]

You need to use the aggregate funtions in a select query.

Start by creating a normal query that lists the information that you want a total of. Then while still in design view click on the Totals button on your tool bar. It looks like a M on it's side. this will then group your fields. then you can change the group by to a count (probably what you want) or even a sum if needed. look further down the list for expression as well to set conditions.

Hope that brief, gets you started