Total calculations wrong on report

[pdtit]

Hey,

I have the following tables / data :

tbl_invoice:
invoicenr customer date discount
1 ALF 15/10/2004 5€

tbl_invoicedetails:
invoicenr product price
1 123 10€
2 456 10€

when I make a totalreport of all invoices, it gives me the following :

total sales 20€ (i.e. sum of products)
discount 10€ !!!!!!!!!! (WHICH IS WRONG)

in fact, the discount is calculated according the number of invoicedetail-lines I have. It should take this value only once.

How can I correct this ?

Regards,

Peter

 

[dhookom]

Don't use
=Sum(Discount)
Do use
[Discount]
or
=[Discount]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[pdtit]

Duane,

I tried this but it doesn't work.

It still gives me the same result.

What can I check ? If you want I can send you a RTF with the report as an example ?

If so feel free to give me your emailaddresse please.

regards,

Peter

 

[pdtit]

Duane,

SOme more info which might be helpfull.

I greated groups based on "payment method" like cash or visa.

It is the total of this group which is wrong; the overall total of all payments is oke.

Does this says anything ?

Peter

 

[dhookom]

What is your control source in the group header or footer that is giving you the wrong results?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.