How do I build an expression accesses other fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top