Solved Cross Tab Query To Display Sum Of Nationalitywize Empls in Dept.

[Ashfaque]

Hi,

I have this cross tab query that I created using wizard and which generates figures to know how many employees employees of which nationality are in different departments. I used this cross tab query as data source to display graph on one form.

TRANSFORM Count(T_JobOffer.CLetterDate) AS CountOfCLetterDate
SELECT T_JobOffer.CLastWorkingDate, T_JobOffer.CNationality
FROM T_JobOffer
WHERE (((T_JobOffer.CLastWorkingDate) Is Null) AND ((T_JobOffer.CNo)>0))
GROUP BY T_JobOffer.CLastWorkingDate, T_JobOffer.CNationality
PIVOT T_JobOffer.CDept;

This is working and presents graph. What I am looking for is: I want to display department names also at the bottom axis of graph that will make the pic more clear.

So each department will have 5-6 numbers of columns in graph that will represent nationalities working in that dept. But even after multiple attempt I am not able to display departments in the graph. If dept. displays then we may have sum of diff nationalities to appear on column.

Can someone help me please?

Thanks,

 

[June7]

Not clear to me what you want. If graph shown is data for only one department, why would there be multiple departments listed under each column?

 

[Ashfaque]

I want all dept names to appear down and appearance of 6 columns in each dept along with thier total number of employees nationality wize.

 

[arnelgp]

can you create the chart on the Table (not query).
design it like this:

 

[Ashfaque]

Excellent....I have removed the cross tab and set it with direct tbl.... It is wokring as desired...
Thank you so much Arnel..