Why doesnt sum(dlookup()) work?

[tom]

I got this working with the dsum function but
why doesnt sum(dlookup()) work?

 

[Albert D. Kallal]

The sum command (as far as I know) only works when you place in a continues
form to total values in the form.

However, I don't think sum ever worked with a dlookup inside, and further,
how would the values/parameters you supply to the sum() command change
inside that function?

If this is a continues form, then dump the dlookup, and use a "join" command
(or sub-query), and then simply use the sum() command in the footer of the
form, or perhaps use a dsum() that would return the same set of records that
the form is filtered on.

 

[Brendan Reynolds]

Because DLookup returns a single value, not a set of values. See the
documentation at the following URL, particularly the paragraph headed
'Remarks'.

http://msdn.microsoft.com/library/d...n-us/vbaac11/html/acfctDLookup_HV05187182.asp

 

[CyberDwarf]

Maybe Dcount is better

Steve

 

[Graham R Seach]

I think you mean DSum().

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia