Calculation Input

[deiopajw]

I have a formula as per the following in a query column:

TranspCost:[Product]*2.46

The 2.46 is the exchange rate between two currencies.

Every few months, that rate changes. Without having to go into the query
itself and change that particular value in the formula - I would like the
user to simply (from a form) press a macro button and then be prompted by a
dialogue box to enter the new rate. This new rate will simply replace the
figure in the query formula.
Any suggestions?
thanks.

 

[Douglas J. Steele]

Why not store the rate in a table, and update the table?

You can then join that table to your query to get the current rate.