Append Query Help

i have a query that multiplies two fields (Brick Quantity and Brick Price) and adds that sum (which is Total Brick Price)to another field (aggregate Price) to make Total Price.

what i want is for this data from this query to be put into a table (tblJob_Price) so that another table (tblInvoice) can also have this data so that an invoice can be produced.

i have made the append query but when i run it, the query doesnt work.

why is this not working. any suggestions? or alternatives?

please help
cheers

Rules of normalization:

"Don't store caculated values."

It is strongly encouraged to NOT store values that can be calcualted on the fly. There a lots of reasons for this, storage space, symplifies programming when updating tables, follows industries norms (so new people coming in, after you are gone, know what you are doing), etc

There are a few reasons to store caculated values, but your example isn't one of them, mostly it has to do with speed issues in running complicated reports and procedures.


If you really procced along this avenue, post your DB and we sill assist you.

S-