Multiply value by unrelated table value

[bibbyd01]

Hi all

I'm running a query in access 2007.

We have an Exchange rate value that is updated in a table, and is the only value in the table. We then update the ex value and want to use it to multiply it against another value.

How do I go about doing that?

 

[John Big Booty]

Perhaps the sample posted here will be of assistance.