D DFISHER New member Local time Today, 15:18 Joined Mar 29, 2001 Messages 6 Apr 2, 2001 #1 I have a dlookup control named Sum of Award. thats in my report. When I have the statement in the footer, sum(sum of award) it will only give me a sum of 0.00 How do I tell it to add all the details?
I have a dlookup control named Sum of Award. thats in my report. When I have the statement in the footer, sum(sum of award) it will only give me a sum of 0.00 How do I tell it to add all the details?
A AccessUser Registered User. Local time Today, 15:18 Joined Mar 28, 2001 Messages 35 Apr 2, 2001 #2 For the sum, use the same command as you did for your lookup but instead of DLookup use DSum.
L llkhoutx Registered User. Local time Today, 09:18 Joined Feb 26, 2001 Messages 4,013 Apr 2, 2001 #3 I think that you =Sum(Dlookup(. . .))
