Saving Trailing Grand Summary

[wakely]

What is the best way to use/copy the Trailing grand summary on a report to use in another file? (If it is possible)!

Thanks in advance, wakely

[LiveOak]

This is kind of a "What's the best car to buy?" or "What's the best way to write a database?" question. The options available will depend upon the structure of your files and the information you are summarizing.

Can we pry a little more detail out of you?

The general (Buy a good one!) answer is "Use Relationships".

-bd

[wakely]

I have an invoice file that prints a report of invoices paid for each date, with a summary total. I also have a Till file that needs the summary total to input to the TookIn field.

I then subtract the TookOut money and the balance should be what is left in the cash register.

Formula: PrevBal + TookIn - TookOut = Present balance!

(I am switching over from Q&A5.0, which uses post to) --- TIA, wakely

[LiveOak]

If you a summing all the records in a file, create a relationship based upon a field:

Constant (calculation, number) = 1

created in each of the files. Call the relationship (Constant). The total of records in the file would then be: Sum(Constant::InvoiceAmt).

If you need to do this by date, base the relationship upon a date field and again use the Sum(Relationship::Field) approach.

-bd

[wakely]

If you need to do this by date, base the relationship upon a date field and again use the Sum(Relationship::Field) approach.

-bd

Hey! Thanks bd That works great. Sum(Date_Paid::Amt_Paid)

Thanks for the help!!!

I enter a new record in the till file and the Sum is auto entered!

wakely