If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to update a field
Hello all,
I have created a query that has project details such as the award cost and want to determine the total cost of the project by bringing in the total cost of change orders (I totalled these as a sum in another query). |
#2
|
|||
|
|||
Trying to update a field
On Fri, 16 Apr 2010 09:38:03 -0700, Brian T
wrote: Hello all, I have created a query that has project details such as the award cost and want to determine the total cost of the project by bringing in the total cost of change orders (I totalled these as a sum in another query). Correct the error in your query. If you would like help doing so, please open the query in SQL view and post it here so folks can see it. Do note that any Totals query, or any query including a Totals query, will NOT be updateable; and that storing a derived field such as a total in a table is generally A Very Bad Idea, since the stored value will become invalid if any of the underlying fields is added, deleted or changed. You're almost always better off just recalculating it as needed. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Trying to update a field
John,
I kept the Total cost separate from the Award Cost in a separate form and that allowed me to do what I needed to. thanks for the help. "John W. Vinson" wrote: On Fri, 16 Apr 2010 09:38:03 -0700, Brian T wrote: Hello all, I have created a query that has project details such as the award cost and want to determine the total cost of the project by bringing in the total cost of change orders (I totalled these as a sum in another query). Correct the error in your query. If you would like help doing so, please open the query in SQL view and post it here so folks can see it. Do note that any Totals query, or any query including a Totals query, will NOT be updateable; and that storing a derived field such as a total in a table is generally A Very Bad Idea, since the stored value will become invalid if any of the underlying fields is added, deleted or changed. You're almost always better off just recalculating it as needed. -- John W. Vinson [MVP] . |
Thread Tools | |
Display Modes | |
|
|