Hi all,
Please could you advise how to continate the following
If Type = Airframe, then no Serial number selected, I only want to see the Airframe records
If Type = Engines, then Serial number is selected, I only want to see the Engine records with the selected serial number
Please could you advise how to continate the following
If Type = Airframe, then no Serial number selected, I only want to see the Airframe records
If Type = Engines, then Serial number is selected, I only want to see the Engine records with the selected serial number
SELECT [Aircraft Overview Temp].Active, [Aircraft Overview Temp].[Aircraft Registration], [Aircraft Overview Temp].Type, [Aircraft Overview Temp].[Engine Serial #], [Aircraft Overview Temp].Chapter, [Aircraft Overview Temp].[Task number], [Aircraft Overview Temp].[Part Number], [Aircraft Overview Temp].[Serial Number1], fncConcat([Description 2],[Description 1]) AS Description1, [Aircraft Overview Temp]![Limit 1] & " " & [Aircraft Overview Temp]![Unit 1] AS Limit1, [Aircraft Overview Temp]![Limit 2] & " " & [Aircraft Overview Temp]![Unit 2] AS Limit2, [Aircraft Overview Temp]![Limit 3] & " " & [Aircraft Overview Temp]![Unit 3] AS Limit3, [Aircraft Overview Temp].[Consumed 1], [Aircraft Overview Temp].[Consumed 2], [Aircraft Overview Temp].[Consumed 3], [Aircraft Overview Temp].[Installation FH1], [Aircraft Overview Temp].[Installation FH2], [Aircraft Overview Temp].[Installation FH3], [Aircraft Overview Temp].Interval, [Aircraft Overview Temp].[Installation Date 1], [Aircraft Overview Temp].[Limit 1], [Aircraft Overview Temp].[Limit 2], [Aircraft Overview Temp].[Limit 3], Replace([Aircraft Overview Temp]![Part Number],Chr(10)," / ") AS [Split Part Nmber]
FROM [Aircraft Overview Temp]
WHERE ((([Aircraft Overview Temp].Type)="Airframe")) OR ((([Aircraft Overview Temp].Type)="Engines") AND (([Aircraft Overview Temp].[Engine Serial #])=[Forms]![AircraftOverview_Edit]![EngineSerial]))
ORDER BY [Aircraft Overview Temp].[Engine Serial #], [Aircraft Overview Temp].Chapter, [Aircraft Overview Temp].[Task number], [Aircraft Overview Temp].[Part Number];