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?
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?