Unfortunately, you have misunderstood the "zillions of answers". They
contend that it is unwise to store totals in a table that can be generated,
when needed, from detail data in the table. That does not apply to what you
want to do.

It is perfectly OK to store a total in a table if it is a one-time,
never-after changing, value.

As you have not described your data, or the layout of your tables, I can
only offer some general guidance. If you have one table, say Project, that
describes the project, and other records with project-related information,
say Project Details, you have two choices: add a field in the Project table
for "InvoiceValue"; or add a Project Detail record, identifying the detail
item as "Invoice Value", with a numeric field for the value.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"granola911 via AccessMonster.com" u56971@uwe wrote in message
news:a864c99ae11a5@uwe...
Hi All,

I have seen the zillions of answers to this that state "never add a total
into the table.." But there are cases, such as mine when it is prefered.

I want to update a project table with the final invoice cost. I want it
entered as a hard figure so that I can then export the table for
accounting
purposes. Additionally, once an invoice has been generated, there isn't
any
need for the total to ever, ever change! In fact it shouldn't.

So the question is.... is there a way to do this?

To update a table with a value from a sum query?

Thanks for any help.

--
Message posted via http://www.accessmonster.com