counting values from a table for the report. help!!

[AJ IT Student]

Hi all.

I'm trying to create a few reports..

I'm having trouble with a specific one, however.

I have a table called OfficeLocation, and a table called Employees.

Each employee is assigned to an OfficeLocation via the LocationID. so in 'Employees' there is a column called LocationID with their appropriate value.

I can create a report with details of each Location (the name of the office, the capacity, the office address...) but I need to have how many people work in each office (a column called Personnel Allocated or whatever).

I don't know how to do this :S. It has something to do with the Count query I think, but how do I tie this in with a report?

Many many thanks
aj

 

[mark curtis]

In your query select the totals button (sigma) on the toolbar and in the grid if you wish to include the employee name use this in a new field:

NoInOffice:[EmployeeID]

and select count from the total field.

Whup there it is!

 

[AJ IT Student]

done it!

gracias senor!