New to access. I know what I want to do but not how

[wanting_to_learn]

Hello,
I apologize before hand for asking this. =( I am having a hard time
grasping concepts with access. I am trying to build a form that represents a
check book. My table has Transaction, Item number, description, debit,
credit, and balance on it. On my form I have used to the wizard to create
all of these fields. I know that I have to "load" a balance on the table in
order to initiate the flow of the database. So lets say I loaded the balance
at 100. Now my problem is how to write the expression, query, or vba to do
what I need it to do.

What I would like to do is when the amount entered into the debit field is >
0, I would like that to trigger to deduct from the balance and carry to the
next line.. I would like the same to happen with the credit, once >0 to add
it to the balance.

I am really sorry to ask such a silly question. I am reading all the books
that I can. I greatly appreciate anyone's help on this. All the coding and
queries have me confused.

Thank you!

 

[Tom Wickerath]

Have you taken a look at the Accounts Ledger template?

http://office.microsoft.com/en-us/templates/TC010175341033.aspx?pid=CT101426031033


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[wanting_to_learn]

I have but unfortunately, I am working out of 2000 at home and it will not
let me download it. I greatly appreciate the suggestion. =)

 

[Tom Wickerath]

If you are interested, send me a private e-mail message with a valid reply-to
address. My e-mail address is available at the bottom of the contributor's
page indicated below. Please do not post your e-mail address (or mine) to a
newsgroup reply. Doing so will only attract the unwanted attention of
spammers.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Wickerath]

Hello LP,

I received a message from you on Friday. I sent a converted version to you,
which you should have received. I also sent a follow-on message with two
images, which show how the PivotChart is not working in Access 2000, and what
it should look like if opened with Access 2002 or 2003. Other than the
PivotChart, the sample seems to be working okay in Access 2000.

If you did not receive these replies from me, then please contact me again.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html

 

[Khaironaja]

I have but unfortunately, I am working out of 2000 at home and it will not
let me download it. I greatly appreciate the suggestion. =)