Often times I need to query data from 2 different tables. One table contains a serial number of a part with it's attributes and another table that holds test data of that same part at multiple stages of testing. Because test data can have the same serial number multiple time it returns the data on multiple lines.
Post Thermal Test: IIf([dbo_SourcesBuilt]![SerialNoSource]=[dbo_SourceTests]![SerialNoSource] And [dbo_SourceTests]![SourceTestStage]="POST_THERMAL","Tested","No")
What is returned is shown below. What need is to show is that is POST_THERMAL test exists return Tested if not return No in same field in the query.
Thanks
Serial GyroSerial Burn In Source Type FailureTypeID Post Thermal Test 452700 454036 KVH Burn-in Standard 1750
No 452700 454036 KVH Burn-in Standard 1750
Tested 452712
KVH Burn-in Standard 1750
No 452712
KVH Burn-in Standard 1750
Tested