Delete and update daily exchange rate

[Mavis]

Hi All,

i have this table (Daily_Rate) to record daily exchange rate for report
purpose. the user will use a excel sheet to update daily exchange rate to
access.

can i know how can i do that by delete the previous day exchange and update
today exchange rate.

I am new to access. Please advice me the step to sovle my question
Thanks in advance.

 

[John W. Vinson]

Hi All,

i have this table (Daily_Rate) to record daily exchange rate for report
purpose. the user will use a excel sheet to update daily exchange rate to
access.

can i know how can i do that by delete the previous day exchange and update
today exchange rate.

I am new to access. Please advice me the step to sovle my question
Thanks in advance.

I'd really suggest a different design: a table with fields for CurrencyType
(e.g. USD, GBP, EURO, YEN), RateDate (date/time), and Rate (Double or Currency
datatype).

You certainly do NOT want a different field for each type of currency. That
may make sense in Excel but it makes your job much harder in Access.