Microsoft Access Help

Matt Krass · #1 21-09-2005, 18:44

Ok everyone, I need your help. I’m trying to create a simple database template for robotics teams in MS Access hopefully to be used in 263s upcoming season, if we have one. I’m using MS Access 2003 and I’m trying to create a Transaction Log table like this.

Code:

Description   Amount   Date    Balance
--------------------------------------
Sponsorship   $11,000 9/21/05  $11,000
Registration ($6,000) 9/22/05   $5,000

The thing is, I want the Balance field to automatically fill in by adding the value of Amount to the previous fields Balance value, or if it’s the first entry in the table then setting the balance equal to the amount. Is there any way to do this?

Thanks all.

JohnBoucher · #2 21-09-2005, 19:41

I can't help, but this is a great reference site for Access Help
http://www.databasedev.co.uk/

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opinion of Microsoft and it's products	mgs	Chit-Chat	22	28-01-2005 18:52
Microsoft Visual SourceSafe	Madison	FIRST-related Organizations	7	13-10-2004 21:18
Access Database help...	kacz100	Scouting	12	18-03-2004 19:18
Any pratical use for Microsoft Visual Studio .NET Pro	Kyle Fenton	General Forum	11	28-01-2003 16:59