Dsum Function

[LOIZOS]

Hi,
I try to use Dsum in a Subform and I am Getting Error Message

My Formula is
Dsum([GrossTotal];[frm_invoices-heater];[Invoice_Type]="CR")


I think that my error is on the source part of the formula
Pls Help

[pbaldy]

See if this helps:

DLookup Usage Samples

[LOIZOS]

Dear Pbaldy

I want To sum up the GrossTotal Amount

Dlookup is not for summation

[pbaldy]

Did you miss the first line of the link?

Note that the same logic applies to most Domain Aggregate Functions (DMax, DMin etc.)

[Missinglinq]

Paul knows you're attempting to sum the field! He's trying to tell you that the Aggregate Functions utilize the same syntax as DLookup(), and your syntax is way off of the mark.

Where you have

frm_invoices-heater

you need to have the name of the domain; a domain is Table or Query, not a Form. Also, Aggregate Functions cannot be run against Calculated Fields, and GrossTotal sounds suspiciously like a Calculated Field.

If, for instance

GrossTotal = Units * UnitPrice

Instead of using

Sum([GrossTotal])

you have to use

Sum([Units] * [UnitPrice])

Linq ;0)>

[LOIZOS]

Thank you for you reply
I fix my formula and i got the sum of a Gross Total
Now I want to get the sum for a specific customer and is not working.
My formula is
Dsum("Gross_Total";"Invoices-header";"Customer_code=" & [Forms]![Frm-invoices-header]![Customer_code])

I also try
Dsum("Gross_Total";"Invoices-header";"Customer_code=" & [Frm-invoices-header].[form]![Customer_code])

Still not working

Thanks

[Missinglinq]

Is Customer_code defined as a Number or as Text? The syntax varies, depending on the Datatype.

Linq ;0)>

[LOIZOS]

Customer_code is a Text

[pbaldy]

I'd refer you back to the link for the syntax adjustment required for text, but...

[LOIZOS]

Paul
pls Complete the formula

Dsum("Gross_total";"Invoices-header";"Customer_code=

Customer_code is a text
the form name is Frm-invoices-heater-data

[LOIZOS]

Paul and Missinglink
pls Complete the formula

Dsum("Gross_total";"Invoices-header";"Customer_code=.................

Customer_code is a text
the form name is Frm-invoices-heater-data