recordset syntax help needed
I am trying to update some reports after adding a quantity component to a donation site. I basically need to find the quotient of 2 fields (detialPrice * detailQuantity) and then SUM those amounts for like entries. Here is what I tried, and I'm getting an error that the column "pplTotal" is unrecognized.
SELECT (orderdetails.DetailPrice * orderdetails.DetailQuantity) AS pplTotal, DetailID, DetailSchool, DetailStudentF, DetailStudentL, sum(pplTotal) AS FRtotal