Solved Help in compiling query (1 Viewer)

[tihmir]

Hi all. I need some help in compiling the following query.

I have two I have two tables - tblInspections, tblSampling and tblSampleType(with 3 fields - KD, PD, RD).
The tblInspections has fields: id, date, employeeName, inspectionType
The tblSampling has fields: id, sampleType, numbersOfSamle, inspection_id (foreign key)

In my query I want to be displayed: date, employee, inspectionType, and only the number of each sampleType.

If I write KD: Sum(IIf([sampleType] Like "KD*";1;Null)) it gave me how many sample of that type has,
but I need displayed for KD numbersOfSamle, for PD numbersOfSamle.
How can I do that?

 

[arnelgp]

can you use Crosstab query?

 

[tihmir]

can you use Crosstab query?

I'm trying, I can't do the task. A little help please

 

[arnelgp]

see query1 (crosstab query).

 

[tihmir]

see query1 (crosstab query).

Sincere thanks, again and again!
As always you arnelgp are accurate and unerring with the decisions!