HELP!!

I have a query, the fields are:

Date..Detail..Staff..Time..Amount..Amount to Date

What I need is for the "Amount to Date" to update everytime a new record is created from the "Amount" field. Example:

Amount..Amount to Date

...10...............10
...10...............20
...10...............30

ETC ETC....

Any ideas???

Thanks!

I think you will find what you want here:
Rogers Access Library (http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=218&SID=de442884b2fcf355593763z8cfaa553b) --- Excellent compendium of Access 2000 routines from Roger Carlson.

Sorry to seem dumb, but which one do I need to go on?

Cheers

You need an update query. Check the help file or do a search.

Opp's Sorry.... I posted the wrong Link.....

Try this one: Running Sum (http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=279)