Access 2013 formula off grouping data

[Anitykk]

Thank you in advance for reviewing my issue. I am creating a database that consolidates employee inspections by location, unit, and accuracy. The data comes in excel format and I have been able to consolidate by name; however when I add a column to calculate the overall accuracy the information gets broken out individually.
The formula I am trying is – Accuracy: ([AdjTLACV]-[TLDetVar])/[AdjTLACV
Here is the Query layout:

Field	MCO	Unit	Name	Count	AdjTLACV	DETLACV	TLDetVar	Accuracy
Table	Adj	Adj	Jan	Jan	Jan	Jan	Jan
Total	Group	Group	Group	Sum	Sum	Sum	Sum
	TB	A	Joe		2,203.48 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	2,203.48 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	0.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	TB	A	Joe		7,002.10 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	6,583.66 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	314.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	X	Eric		4,334.95 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	4,100.88 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	308.07 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	P	Phil		9,000.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	8,865.38 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	370.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	P	Phil		9,115.92 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	8,731.43 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	217.40 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	TB	X	Steve		7,913.70 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	7,879.70 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	276.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	H	Jim		4,803.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	4,683.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	193.62 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	TB	X	Sam		7,679.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	7,314.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	364.51 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	V	Bob		11,934.56 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	11,427.88 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	478.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	P	Phil		10,026.46 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	9,986.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	214.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>
	SF	V	Bob		3,413.30 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	3,241.03 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>	161.00 <colgroup><col width="64" style="width:48pt"><tbody> </tbody> <strike></strike>

<tbody>
</tbody>

 

[Anitykk]

I figured it out- when I summed the three fields named -

AdjTLACV

DETLACV

TLDetVar

<tbody>
</tbody>

the query field name changed to sum of (named field), therefore until I changed my formula to the query field name it would not work.

Thanks to all who viewed the post.