Hi

I have 2 fields - "Balance" and "Date" - each time data in the "balance" field changes, the "Date" field updates to todays date (thanks to help from Kiwiman in the forum earlier).

I now need to keep a history/log of all data input into balances and the dates.

The new field to store this information is called "Balance History". so an example of what i want to end up with would be

01/01/08 300.00
01/02/08 250.00
12/02/08 210.00

Any help would be greatly appreciated

Thanks

Geoff

That is called an audit log (http://allenbrowne.com/AppAudit.html) or audit trail. There are other examples if you search this forum.