here is a series of request that combine to finally obtain a "Fuel Range check" sheet. One still have to export it it excel and create the formulas to calculate the fuel range and then compare it with the weapon's range but, well, at least all figures are centralized on one single sheet.
QueryList_WeaponEngine
SELECT t2Weapon.ID, t2Weapon.Name, t2Weapon.Designation, t2Weapon.MaxLaunchRange, t2WeaponEngines.ItemID
FROM t2Weapon INNER JOIN t2WeaponEngines ON t2Weapon.ID = t2WeaponEngines.ID;
QueryList_WeaponEngine_CruiseSpeed
SELECT QueryList_WeaponEngine.ID, QueryList_WeaponEngine.Name, QueryList_WeaponEngine.Designation, QueryList_WeaponEngine.MaxLaunchRange, t2PropulsionAltSpd.Speed
FROM t2PropulsionAltSpd INNER JOIN QueryList_WeaponEngine ON t2PropulsionAltSpd.ID = QueryList_WeaponEngine.ItemID
WHERE (((t2PropulsionAltSpd.Throttle)=2));
(Throttle 2 is cruise speed)
QueryList_WeaponEngine_Speed_Fuel
SELECT QueryList_WeaponEngine_CruiseSpeed.*, t2WeaponFuel.ItemID
FROM t2WeaponFuel INNER JOIN QueryList_WeaponEngine_CruiseSpeed ON QueryList_WeaponEngine_CruiseSpeed.ID = t2WeaponFuel.ID;
QueryList_WeaponEngine_Speed_Capacity
SELECT QueryList_WeaponEngine_Speed_Fuel.ID, QueryList_WeaponEngine_Speed_Fuel.Name, QueryList_WeaponEngine_Speed_Fuel.Designation, QueryList_WeaponEngine_Speed_Fuel.MaxLaunchRange, QueryList_WeaponEngine_Speed_Fuel.Speed, t2Fuel.Capacity
FROM t2Fuel INNER JOIN QueryList_WeaponEngine_Speed_Fuel ON QueryList_WeaponEngine_Speed_Fuel.ItemID = t2Fuel.ID;
cheers,
Jan