Adding Balance

[Guest]

Please Help me for this,
I have one table name tCustomerBalances having BalDate;CustomerID,
CusBalance Fields. On the form I have BeginningDate,EndingDate,CustomerID,and
OpeningBalance Fields.
I m entering beginning and Ending dates, I will sellect CustomerID from
Listing.
In OpeningBalance, I want to to calculate or add CusBalance for selected
customer where <= Ending date.

Please solve my query, thanks in advance
Wahab

 

[Guest]

Stop! Don't Move! Put your hands in the air and back away from the computer!

You should do some reading on these Access sites. It is a bad practice to
carry any calculated data in a database. That is one of the basic principles
of database design. To quote something I read 20 years ago - "If you think
you need to store a calculated value in your database, you don't understand
the problem"

The correct way to do what you want to do is to perform the calculations
only when you need to present it to a user. That would be on a form, a
report, or in a Select query that would be used in a form or report.

 

[Guest]

Thanks for your reply, I dont want to store calculation in the table, my
point behind asking question is that I want to create receivable/Debtors
ledger where every month opening balance or balance c/f is there, I wnat to
show the transaction between beginning and ending date as balance B/f.

I f you have some good idea please share it.
one again thank you very much.
I dont feel bad about you comment, reading is good habbit which wil bring
more ideas.