Is it possible to show the difference in value of each line in a report i.e.
ID Widgets Cost Diff 1 12.78 0.00 2 67.98 55.20 3 56.88 -11.10
show value difference by line
Competent Performer
Windows 8 
Access 2010 64bit
Is it possible to show the difference in value of each line in a report i.e.
ID Widgets Cost Diff 1 12.78 0.00 2 67.98 55.20 3 56.88 -11.10
VIP
Windows 7 64bit Access 2010 32bit
Having record pull value from another record in same table can be tricky. One way is nested subquery. Review: http://allenbrowne.com/subquery-01.html#AnotherRecord
Another method requires the ID field to be sequential with no gaps.
Another method uses domain aggregate function.
Last edited by June7; 06-17-2014 at 08:33 AM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Use the result of a recordset without moving through it line by line?
Posting Permissions
Reply With Quote