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

 

[reclusivemonkey]

Use an UPDATE query?

 

[Wolfman24]

if i use update query.. it will change all the rates.. i mean.. the previous transaction...

ist there any way to create an popup window or form and the administrator will update the rate field..???

 

[Wolfman24]

ahmm im so sorry i think i made a mistake about posting with attachment..could u reffer to the second post i made...that shows tha attachment.. thanks.. and also im a newbie in access ..

 

[reclusivemonkey]

No attachments here I'm afraid. You need to zip a DB first, then post it. Also you need to make sure you don't exceed the file size.

 

[Wolfman24]

yah.. thanks again..

ive made another post... same thread.. ive got my attachment there.. thanks. once again