morning1001
New member
- Local time
- Today, 13:18
- Joined
- Aug 8, 2000
- Messages
- 7
I have a table displaying all records. There is a comments field for modified records (e.g new, amended, or deleted). This way all edits are retained in the table.
In my report I have totaled each records amount in the group header. My problem is the deleted records are included in the calculation. How can I display all records (even those deleted) and only calculate a total on the remaining records?
Should I actually delete the amounts in the deleted records and type in the amount deleted in the comments field?
I tried using the dsum function in the report but my totals are in a fiscal year header and the dsum calculated the total regardless of fiscal year.
[This message has been edited by morning1001 (edited 10-16-2000).]
In my report I have totaled each records amount in the group header. My problem is the deleted records are included in the calculation. How can I display all records (even those deleted) and only calculate a total on the remaining records?
Should I actually delete the amounts in the deleted records and type in the amount deleted in the comments field?
I tried using the dsum function in the report but my totals are in a fiscal year header and the dsum calculated the total regardless of fiscal year.
[This message has been edited by morning1001 (edited 10-16-2000).]