Can't get alias working in query

[sheckay]

Hello. This question is probably pretty simple for an experienced person. I'm trying to work with expanding a query that a form is based off of. The numbers are coming in for quantity and unitprice. The aliases I need are: totalprice, totalpartslabor, totaltax, and subtotal. And it seems that the only one that's causing trouble is totalpartslabor which would be the sum of totalprice (if there's more than one item on the ticket). So, in the column after totalprice: [quantity]*[unitprice] I have the column for TotalPartsLabor. For that column I have TotalPartsLabor: Sum([Totalprice])
But it doesn't work when I have that in there. What am I doing wrong?
Thanks in advance.

[mike60smart]

Hi
The Sum of TotalPrice would normally be displayed in the Form Footer and not in the Individual Record

[Welshgasman]

I believe you would need an aggregate query for that.