Update Table form other calculated Table (1 Viewer)

[theinviter]

Dears;
I have Table1 "Customer" contain date, a
And Table2 " Request" contain data which is converted to form and have calculated field through query.
the field:
ID
Item_Name
Item_Code
Quantity
so I want to Update the matching record BY ID , and if no record then add a new record to table " Customer"

so how to do it?

 

[Pat Hartman]

If the query aggregates data, it will not be updateable nor will it be able to be used in a query that updates a different table.

Storing calculated data is almost always wrong. What are you trying to store?

 

[theinviter]

If the query aggregates data, it will not be updateable nor will it be able to be used in a query that updates a different table.

Storing calculated data is almost always wrong. What are you trying to store?

i am trying to Extract the data from another table and doing calculation in query, then wanna update this result in customer table. as they are unable to update.

 

[Pat Hartman]

I heard you the first time and I explained that certain types of queries are NOT updateable. All you did was repeat the same comment. How are we going to get to your problem if we don't know exactly what that query is doing?

Please post the update query. If the query references another query, the one that does the calculations, we need to see that also.