Bank account database & sum of column

[Rasoul Khoshravan Azar]

I want to make a bank note database in access2000.
My fields:
TransactionId (autonumber) PK
BankName
Amount (positive numbers for deposits and minus numbers for withdrawal)
I considered one field for deposits and withdrawals but it is possible to
take two fields for them separately. They might have their advantage and
disadvantages.
Date
Note

I want to get the total of Amount column.
1- Is it possible to do this in query? How
2- Should I do this in Report? How

Sorry for a beginner question. I don't think it is difficult question but my
Access knowledge is not enough.
TIA & Very Sincerely Yours

Rasoul Khoshravan Azar

 

[Rasoul Khoshravan Azar]

Dear John Vinson

It is good to hear from you again.
You have solved some of my basic issues in Access a couple of years ago in
these ng's. I always remember your kind solutions with patiency in answering
questions.

I didn't expect my question is reinventing the wheel. I have faced many
occaisions that I need to use the content of a previous field in present
record.
If it has a straight forward solution, let me know.

Could you please name few shareware/freeware you have mentioned for this
purpose? Is there any one written in Access?

Will appreciate your comments
TIA
Rasoul

I want to make a bank note database in access2000.

Ummmm... why?

That's reinventing the wheel; you'll spend FAR more (if you charge any
plausible amount for your time) effort developing it than it would
cost you to purchase Microsoft Money, or Intuit's Quicken (though I
admit I've angrily expunged it from my system, see if you can get an
older version), or one of the many shareware/freeware checking account
management programs.

My fields:
TransactionId (autonumber) PK
BankName

Use AccountNo as well - it's routine to have (say) a savings,
checking, and credit card account at the same bank.

Amount (positive numbers for deposits and minus numbers for withdrawal)
I considered one field for deposits and withdrawals but it is possible to
take two fields for them separately. They might have their advantage and
disadvantages.

Date

Change the fieldname. Date is a reserved word.

Note

I want to get the total of Amount column.
1- Is it possible to do this in query? How
2- Should I do this in Report? How

A Totals query (click the Greek Sigma button) will give you one
option; a textbox in the Report's Footer with a control source

=Sum([Amount])

is another method.

Sorry for a beginner question. I don't think it is difficult question but my
Access knowledge is not enough.
TIA & Very Sincerely Yours

You're welcome!

John W. Vinson[MVP]

 

[John Vinson]

I want to make a bank note database in access2000.

Ummmm... why?

That's reinventing the wheel; you'll spend FAR more (if you charge any
plausible amount for your time) effort developing it than it would
cost you to purchase Microsoft Money, or Intuit's Quicken (though I
admit I've angrily expunged it from my system, see if you can get an
older version), or one of the many shareware/freeware checking account
management programs.

My fields:
TransactionId (autonumber) PK
BankName

Use AccountNo as well - it's routine to have (say) a savings,
checking, and credit card account at the same bank.

Amount (positive numbers for deposits and minus numbers for withdrawal)
I considered one field for deposits and withdrawals but it is possible to
take two fields for them separately. They might have their advantage and
disadvantages.

Date

Change the fieldname. Date is a reserved word.

Note

I want to get the total of Amount column.
1- Is it possible to do this in query? How
2- Should I do this in Report? How

A Totals query (click the Greek Sigma button) will give you one
option; a textbox in the Report's Footer with a control source

=Sum([Amount])

is another method.

Sorry for a beginner question. I don't think it is difficult question but my
Access knowledge is not enough.
TIA & Very Sincerely Yours

You're welcome!

John W. Vinson[MVP]