Help, How to update field

[Wolfman24]

Hi.. I am creating a database for a friend.. database is for Money remittance.. Ive attached the first step I did.. my problem is.. everyday money rates changes and i need to find a way how to update the rates so that the encoder dont have to fill the "Peso Rate" everytime they have a transaction.. how could i create an update for the rates only once...and also update the dailyrates that will not affect the previous transaction..for example..yesterday was 32.00 and today is 52.00. i want to preserve the previous transaction rates..but could update daily rates.. sorry if i cant explain it very well..
pls..i need help.. thanks!

WOLFMAN

 

[neileg]

Create a rates table with date and rate. Prompt the user to set today's rate when the db is opened. Use DMax() in your form to get the latest date and corresponding rate to use in your form.

 

[Wolfman24]

Neileg.. thank you for the reply... but.. i dont have the knowledge to the procedures that uve told me.. could u make a sample mdb?? thanks.. and best regards...

wolfman

 

[neileg]

My rate is 1,495 GB pounds per day, plus expenses....

Create the table first. Put some sample data in it.

Now read up in Access Help on how to use DMax().

Build an unbound form and insert a text box that uses Dmax() as its data source. Assuming you get this right, it will return the latest price from your table. Add a new rate to your table and ensure that when you reopen your form it returns your new data.

When you've done that, come back and we'll take another step.