Calculated Query with user "margin" input

[Gilberto]

Hello,

I have two tables: COSTING and PRICING, both with the following fields:
product name French
packaging
transportation
ddp

I want to create a query so that from a text box in the pricing form the user could enter a desired "margin" (ie. 10%) and the query would replace everything in the pricing table with the data from the costing table multiplied times the margin entered in the text box.

how can i accomplish this???

so far i can update the pricing table with the costing data with a action (update) query, but im still missing how to integrate the user "margin" input. At the same time i have the problem that the query limits the update only to the products that are ALREADY in the pricing table. So it doesn't copy ALL the products from the Costing table.

Thanks,
Gilberto

[NeoPa]

Gilberto,

I need you to express you situation a little more precisely. Your current explanation doesn't really explain all the possibilities very well.

Before you do though, are you sure you want to store this information in a table at all? It seems to me (at first glance - I could be mistaken) that a query designed to update the prices by a margin would be a better approach. After all, a query can be used in almost all situations a table can.