S SpursGirl Registered User. Local time Today, 04:58 Joined Nov 10, 2005 Messages 11 Oct 26, 2010 #1 DSum("[Payment]","tblocrbackup","RecordNumber") The above formula I have but into a control box but instead of a running total it is just summing up all the totals.... Help!!
DSum("[Payment]","tblocrbackup","RecordNumber") The above formula I have but into a control box but instead of a running total it is just summing up all the totals.... Help!!
pbaldy Wino Moderator Staff member Local time Today, 04:58 Joined Aug 30, 2003 Messages 36,157 Oct 26, 2010 #2 The criteria is not correct: http://www.mvps.org/access/general/gen0018.htm
S SpursGirl Registered User. Local time Today, 04:58 Joined Nov 10, 2005 Messages 11 Oct 26, 2010 #3 added on the following now getting a Name? error =DSum("[Payment]","tblocrbackup","RecordNumber>0" & [Forms]![FrmOCRBackup]![Text22])
added on the following now getting a Name? error =DSum("[Payment]","tblocrbackup","RecordNumber>0" & [Forms]![FrmOCRBackup]![Text22])
pbaldy Wino Moderator Staff member Local time Today, 04:58 Joined Aug 30, 2003 Messages 36,157 Oct 26, 2010 #4 Is that 0 really in there?
