Bank account database & sum of column

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

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
"John Vinson" wrote in message
...
On Thu, 2 Feb 2006 11:22:09 +0330, "Rasoul Khoshravan Azar"
wrote:

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.

They do indeed... g

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]

On Thu, 2 Feb 2006 11:22:09 +0330, "Rasoul Khoshravan Azar"
wrote:

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.

They do indeed... g

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]