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

W

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!
 
W

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. =)
 
T

Tom Wickerath

T

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
 
K

Khaironaja

wanting_to_learn said:
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. =)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top