Can Calculated fields become fields in other tables 1

[Gavroche00]

I have a total (it sums a few records) at the bottom of a report. I want this number to become a value in a table that I would call Invoices to be paid. That way I could make a check box next to it and cross reference it. This is obvious in excel. I am new to Access, and I don't see how this could be done since teh total is a calculated control and not an input. Thanks for answering.

 

[danvlas]

Database rule:
Do NOT store calculated values in tables.
They can always be retrieved provided the calculation elements do not change.

There are cases when you have to make a compromise between data normalization and speed...but do things by the book first.

Even in Excel you don't store the value - it is calculated and referenced...

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html