Hi

In Access 2000, I need to setup a currency field that as a default value of
a number stored in another field (in same table) by a currency value (in
different table).

I realise this is a basic question, but I'm new to expressions.

Thanks

Not really sure what you are aksing. You would need to give us specifics.

If you have two tables with data that are linked in some way, pull both
tables into your query. Then you can use fields from each of them in your
forms or reports.

For example, if you are storing a dollar figure and a currently type in one
table and you have a different table that stores currency type and exchange
rate, then you could link them using the currency type field and use math to
calculate results.

Post more details. Include your table structure, which fields are in each
table. What calculation you wnat to perform, and where you are doing this
(query, form report?)

Rick B


"ear-lution" <ear-(E-Mail Removed)> wrote in message
news:4CD47925-DBC1-4BDE-859E-(E-Mail Removed)...
> Hi
>
> In Access 2000, I need to setup a currency field that as a default value
of
> a number stored in another field (in same table) by a currency value (in
> different table).
>
> I realise this is a basic question, but I'm new to expressions.
>
> Thanks