I am trying to get the total for all the items in a column. I am working on an invoice database. In the extended Orders Details Query I have an Column that is ExtendedUnitPrice: IIf([Status]=1,[Order Details].UnitPrice*[Quantity],0). This allows for the invoice to show items order but not calculated in totals.
My problem is now I can not total the ExtendedUnitPrice; I have used Sum(ExtendedUnitPrice) and get an error. I have also tried =Sum([Orders Subform].Form!ExtendedPrice) and still get an error. Can anyone tellme how I can total a column.
Thanks