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!!
Help! I recently used a macro to open a database within another and accidentally deleted the macro. Now i can't remember how I created the original macro...can someone please help me:o .
:confused: Need help building a query that will subtract the previous value from the next value at each change in date
Date Tier 1
1/6/2006 4.22
1/13/2006 4.27
1/20/2006 4.27
1/27/2006 4.314
2/3/2006 4.314
for example, 4.22-4.27 = -0.05