J
James Proctor
HI there, ive got one query which asks for a Incoive ID, and then displays all of the items on that invoice. With the total price of each item, e.g. Unit Price x Quantiy. I then want to be able to have another query which shows the invoice details, such as who it is going to and things, but i would like to take the sum of the total prices from the first query and put it into the second query. I cant seem to master this. Ive tried having a field which is
=Sum([Invoice(ID) Query]![InvoiceItem_TotalPrice]
But when i do this i just get the error saying that i havent included the specified expression 'Invoice_ID(LNK)' as part of an aggregate function. What does this mean? Invoice_ID(LNK) is in the query already in a seperate field by the way
Anyone know of any tutorials on topics like this, or any help would be great
Thank
JP
=Sum([Invoice(ID) Query]![InvoiceItem_TotalPrice]
But when i do this i just get the error saying that i havent included the specified expression 'Invoice_ID(LNK)' as part of an aggregate function. What does this mean? Invoice_ID(LNK) is in the query already in a seperate field by the way
Anyone know of any tutorials on topics like this, or any help would be great
Thank
JP