count again please help... im stuck on it

[jeimen via AccessMonster.com]

can you help me please,
i want a report that show the total count of employee per position by site...

example:

site position count of employee

taikisha installer 3
welder 2
i want something like that... can you give me a query on how to run this kind
of report.. thanks in advance

add for this...

i want them to be like that when i enter the start and end date of there
contract to that site...

that information is coming from tblProjAssign from my database...
the table look like this... with example data

ProjID ProjectName Principal PrincipalAddress Place of Work
Position Start EndDate
1 Toshiba khhkkjjhj jhjkhjhjkhjkhjj
philippines installer 02/1/08 03/14/08

i want that when i enter the startdate and enddate in will reproduce the
first example i show on the top...

 

[Stefan_889_12]

Hello,

the first simple query {no dates limit}

SELECT tblProjAssign.[Place of Work], tblProjAssign.Position,
Count(tblProjAssign.Position) AS CountOfPosition
FROM tblProjAssign
GROUP BY tblProjAssign.[Place of Work], tblProjAssign.Position;

limit of dates:

PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime;
SELECT tblProjAssign.[Place of Work], tblProjAssign.Position,
Count(tblProjAssign.Position) AS CountOfPosition
FROM tblProjAssign
GROUP BY tblProjAssign.[Place of Work], tblProjAssign.Position,
tblProjAssign.EndDate, tblProjAssign.Start
HAVING (((tblProjAssign.EndDate)<[Enter End Date]) AND
((tblProjAssign.Start)>[Enter Start Date]));


Stefan.