Hi , I'm beginner in programming a 1

[fule12]

Hi ,
I'm beginner in programming and if someone can help me with my problem.
I have table "Order" and 3 field CurrencyID, EstCost and EstCostUSA. CurrencyId is combobox from where I chouse value in different Currency.( I  have form Currency with CurrencyID,CurrencyRate, ect .. ect)
So I make form with 3 field currencyId,EstCost and EstCostUSD and
In EstCostUSD. In Field EstCostUSD I nead score from =[EstCost]/[CurrencyID], I need same code to make ..but I do no how? HELP
Thanks Fule

 

[gusbrunston]

Hi,

I think we are all beginners, some just started a little earlier.

It looks like you've got it right, except you need to know where to put

 " =[EstCost]/[CurrencyID] "

.

I do worry that CurrencyID is not actually the factor you want ("CurrencyID" sounds like a unique key identifier). Are you trying to divide something like:

     1000.00 / 1.8503

?

Since it is a calculated control it shouldn't go into the table; but I think you could calculate it in a query, or on the form. Put your formula as a field in query that is the data source for your form, or else put it in an unbound text box control on your form.

I hope this helps. If not, we'll try again. Gus Brunston An old PICKer, using Access2000
gustrel@aol.com

 

[fule12]

Maybe I need to explain from beginning
I have 2 tables 1. Order with field CurrencyID, estCode and EstCodeUSA, and second table with CurrencyID, CurrencyRate,CurrencyName….So I make Form with ComboBox and 2 text box >Combo box have 3 field .CurrencyName,CurrencyID and CurrencyRate ,two field are EtsCode And EtsCodeUSA .So I put code in After Update for EstCode
Me!EstCostUSD = (Me!EstimateCost / Me!CurrencyID.Column(2))
And in combobox After Update : Me!EstCostUSD = (Me!EstimateCost / Me!CurrencyID.Column(2)) and is give me good results in EstCostUSD, end I go to next record and ect , ect but problem star when I change value in table Currency in field CurrencyRate…in form old record in combobox are empty ???
My question is how to fix this so if I change value of Currency Rate count only for new record?
Fule

 

[gusbrunston]

Hi, Nicola:
I sent you (by email) a very small database with 2 tables (tblOrders, tblLookUpExchangeRate), a query, and a form. The table, tblOrders has two records, the query selects them and the form displays them. I hope this will either 1) help you solve your problem, or 2) show that I don't understand what you need. Remember, I'm using a version called Access2000 and you may not get the same results by using an earlier version of Access.

Best of luck,
Gus Brunston An old PICKer, using Access2000
gustrel@aol.com