Accumulated Begning Balance In Report

[djwasim]

Hello All
I am a new user and having problem in ms access report.

How can i get the ledger of some account in ms access report for a specific period with previous closing balance. For Example

For Example here is an whole Month ledger i.e

Date Qty Rate Amount Balance
01/01/01 1 5 5 5
01/02/01 2 5 10 15
01/03/01 5 5 25 40
01/04/01 2 5 10 50
01/05/01 3 5 15 65
01/06/01 2 5 10 75


Now i want to get this ledger for a specific period with opening balance like......

Opening Balance At 01/03/01 is 15

01/03/01 5 5 25 40
01/04/01 2 5 10 50
01/05/01 3 5 15 65

I hope that my first thread should be prefer first.......
Please give me your reply as soon as possible.

 

[khawar]

You can use dsum or a query to get previous balance

Take a look at my sample database Sample Accounting Application

It has a report which shows opening balance as per date selected

 

[djwasim]

Thanks Khawar
you have send me the sample database but in that sample you have made a query in SQL but i don't know about SQL.
So if you can send me that sample in simple access query then i will be very thankful to you.

Dj Wasim

 

[khawar]

Its a union query in access it cannot be viewed in design view
However here is a quick sample for you using Dsum

 

[djwasim]

Thank you so much khawar
you really solve my big problem

but now i have another problem than can i use a query path instead of table name in your dsum formula for accumulated balance?

 

[djwasim]

HI khawar
thank u so much to solve my problem

there is another question that
can i use the Query instead of a table in d sum formula(in your sample database) you have sent me.

 

[khawar]

Yes you can just replace the name of query with the table name

 

[djwasim]

i have replaced it but there is nothing to show in that feild.
can u send me the sample database again after changing.

 

[khawar]

you can not get data from query on which ledger is based because it doesnot have the opening transactions it is filtered to show transactions which are between ledger period

 

[djwasim]

but sir i want to get filtered opening balance for a specific category.
is it possible?

 

[khawar]

Can you upload your sample database

 

[djwasim]

i have uploaded my sample database in which i want to get result category wise.
Plz help me.View attachment Running Balance Sample.mdb

 

[khawar]

Ammended sample is attached

 

[djwasim]

Thank You So much Sir For your cooperation

 

[djwasim]

Morning Sir

Today i have an other problem.
Is it possible that we can hide a field in ms access report if another field is Null or 0

For instance

i want to hide (xyz) field if (abc) field is null or zero.

Wasim Shahzad

 

[khawar]

Write this code in the onformat event of section (in which your control resides)

if isnull([abc]) or [abc]=0 then
     [xyz].visible = false
else
     [xyz].visible = true
end if

 

[Hamza Aslam]

Ammended sample is attached

I Could not open this file
Please Guide Me

 

[Gasman]

I Could not open this file
Please Guide Me

@Hamza Aslam This is a 11 year old thread? !!!
Best to post a new question with details of your problem if you need help?

FWIW the file in the zip is an incomplete safari download file.

 

[Hamza Aslam]

@Hamza Aslam This is a 11 year old thread? !!!
Best to post a new question with details of your problem if you need help?

FWIW the file in the zip is an incomplete safari download file.

How we can get in specific ledger`s Opening Balance by using Beg Date End Date with Specific Account No. ???