As a test, add nTotal to the group by clause...it won't give you the result you want, but I want to see if it eliminates the error.
>No same thing.
>-Mark
>
>>Have you tried (it still may not work because of sum of multiplied fields?):
>>
>>
>>SELECT invoice.nInvoiceNumber, invoice.dInvoiceDate,
>>SUM(invoicedetail.nQuantity*invoicedetail.nUnitPrice) AS nTotal
>>FROM Invoice, InvoiceDetail
>>WHERE Invoice.nID = InvoiceDetail.nParentID
>>GROUP BY nInvoiceNumber, dInvoiceDate Order BY nInvoiceNumber
>>
>>
>>>What is wrong???????? I know I can bypass the problem with the SET ENGINEBEHAVIOUR 70, but I would really like to know what the correct syntax should be.
>>>
>>>TIA
Steve Gibson