Calculating selected records in group header (1 Viewer)

[morning1001]

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).]

 

[Jack Cowley]

You could add a Yes/No field to your table with default set to No. When a record is deleted change the field to Yes. Now you can select only 'Active' records using a query the selects only records with No in the Yes/No field. Or you could use your DSum and find only records with No in that field....

HTH,
Jack