Second query gets the sums of present and proposed values for black and color.


select fg.organizations_id, fg.school_year, fyers.move_to, fyers.present_black_volume, fyers.proposed_black_volume,
present_color_volume, proposed_color_volume
from fyers
INNER JOIN fyer_groups fg ON fg.fyer_grp_id = fyers.fyer_groups_id
where move_to LIKE('Trade%')
and fyer_year = 2022;

select fg.organizations_id,
SUM(fyers.present_black_volume), SUM(fyers.proposed_black_volume),
SUM(present_color_volume), SUM(proposed_color_volume)
from fyers
INNER JOIN fyer_groups fg ON fg.fyer_grp_id = fyers.fyer_groups_id
where fg.fyer_final = 'Y' #move_to LIKE('Trade%')
and fyer_year = 2022
group by fg.organizations_id;



Bob gets the fyer report data with these queries
SELECT tblWhatIf.ID,
Get_vendor_name_fyerRpt.VendorName,
local_machine_types.type_name AS MachineType,
tblWhatIf.PropVol,
[PropVol]/12 AS MonthlyVol,
tblWhatIf.PropCost AS ProposedCost,
(([PropVol]*[PropCost])/12)*[XMonth] AS [80%ofMonth],
sd_organization.government_lease AS GovrmtLease,
Month([sd_organization].[LastUpdate]) AS [Month],
13-Month([sd_organization].[LastUpdate]) AS MO1,

IIf([Month]>8,[MO1]+6,IIf([Month]<7,[MO1]-6,10)) AS Xmonth,

sd_organization.LastUpdate AS UpgradeDate,
FYER_Group.FyerYear AS [Year],

IIf([Color]=1,"C","B") AS BC,

FYER_Group.FyerSavename AS SavedName,
FYER_Group.FyerGroupId,
sd_organization.dateNewUpgrade,
FYER_Group.FyerFinal INTO [FYER BLACK PROPOSED VOLUME]

FROM (sd_organization
INNER JOIN ((tblWhatIf
INNER JOIN local_machine_types ON tblWhatIf.GroupTag = local_machine_types.id)
INNER JOIN FYER_Group ON tblWhatIf.save_name_id = FYER_Group.FyerGroupId)
ON sd_organization.id = FYER_Group.FyerOrg_id)
LEFT JOIN Get_vendor_name_fyerRpt ON tblWhatIf.VendorName = Get_vendor_name_fyerRpt.vendorid_txt

GROUP BY tblWhatIf.ID, Get_vendor_name_fyerRpt.VendorName, local_machine_types.type_name,
	tblWhatIf.PropVol, [PropVol]/12, tblWhatIf.PropCost, sd_organization.government_lease,
	Month([sd_organization].[LastUpdate]), 13-Month([sd_organization].[LastUpdate]),
	sd_organization.LastUpdate, FYER_Group.FyerYear,
	
	IIf([Color]=1,"C","B"), FYER_Group.FyerSavename, FYER_Group.FyerGroupId,
	sd_organization.dateNewUpgrade, FYER_Group.FyerFinal

HAVING (((FYER_Group.FyerGroupId)=[Forms]![frmReportSavedTbls]![txtSaveNameId]))
ORDER BY tblWhatIf.ID;

SELECT tblWhatIf.ID, Get_vendor_name_fyerRpt.VendorName, local_machine_types.type_name AS MachineType, tblWhatIf.ProjColorVol, [ProjColorVol]/12 AS MonthlyVol, tblWhatIf.NewColorCPC AS ProposedCost, (([ProjColorVol]*[NewColorCPC])/12)*[XMonth] AS [80%ofMonth], sd_organization.government_lease AS GovrmtLease, Month([sd_organization].[LastUpdate]) AS [Month], 13-Month([sd_organization].[LastUpdate]) AS MO1, IIf([Month]>8,[MO1]+6,IIf([Month]<7,[MO1]-6,10)) AS Xmonth, sd_organization.LastUpdate AS UpgradeDate, FYER_Group.FyerYear AS [Year], local_machine_types.color AS BC, FYER_Group.FyerSavename AS SavedName, FYER_Group.FyerGroupId, sd_organization.dateNewUpgrade, FYER_Group.FyerFinal INTO [FYER COLOR PROPOSED VOLUME]
FROM (sd_organization INNER JOIN ((tblWhatIf INNER JOIN local_machine_types ON tblWhatIf.GroupTag = local_machine_types.id) INNER JOIN FYER_Group ON tblWhatIf.save_name_id = FYER_Group.FyerGroupId) ON sd_organization.id = FYER_Group.FyerOrg_id) LEFT JOIN Get_vendor_name_fyerRpt ON tblWhatIf.VendorName = Get_vendor_name_fyerRpt.vendorid_txt
GROUP BY tblWhatIf.ID, Get_vendor_name_fyerRpt.VendorName, local_machine_types.type_name, tblWhatIf.ProjColorVol, [ProjColorVol]/12, tblWhatIf.NewColorCPC, sd_organization.government_lease, Month([sd_organization].[LastUpdate]), 13-Month([sd_organization].[LastUpdate]), sd_organization.LastUpdate, FYER_Group.FyerYear, local_machine_types.color, FYER_Group.FyerSavename, FYER_Group.FyerGroupId, sd_organization.dateNewUpgrade, FYER_Group.FyerFinal
HAVING (((local_machine_types.color)<>0) AND ((FYER_Group.FyerGroupId)=[Forms]![frmReportSavedTbls]![txtSaveNameId]))
ORDER BY tblWhatIf.ID;