How to get Dr Cr Report???

[Malik via AccessMonster.com]

How Can I get a report Like this???

 

[Damon Heron]

Add two textboxes, lets call them text1 and text2, set their visible
properties to false, and their running sum= Over Group. The Control source
of text1 would be CR, text2 DR.
Then the Balance textbox would have a control source of [text1]-[text2]
(no running sum on balance)

Damon

 

[Malik via AccessMonster.com]

Add two textboxes, lets call them text1 and text2, set their visible
properties to false, and their running sum= Over Group. The Control source

Thanks for reply

But Define it more If u could
"their running sum= Over Group"

Bcus I m not much Experienced with Access

Thanks

 

[Damon Heron]

In design view, your report will have various controls, like textboxes,
labels, etc. If you right-click, and select Properties for a control, you
will see a property sheet, with 5 tabs. The data tab is where you set the
controlsource and running sum for the textboxes. It can be no,over group,
or over all. By setting the property to over group, it keeps a running
total of the control. So if the first Debit record is 2000, the second
1200, the third 500, the textbox would show a running total of 3700. The
same with the Credit. Note that these are hidden (visbile set to false) -
you are just using these to calculate your balance textbox by subtracting
the difference.

Understand??
Damon

 

[malik via AccessMonster.com]

In design view, your report will have various controls, like textboxes,
labels, etc. If you right-click, and select Properties for a control, you

I Have Done This. Its Ok.

But How To Show The Cr or Dr with Balance.

 

[Damon Heron]

Add yet another textbox to the right of the balance textbox. Set its align
property to Left. In the
controlsource, type: =IIf([yourBalancetxtboxname]<0,"CR","DB")

Damon

 

[Malik via AccessMonster.com]

Add yet another textbox to the right of the balance textbox. Set its align
property to Left. In the
controlsource, type: =IIf([yourBalancetxtboxname]<0,"CR","DB")

Damon

WoW , Its working Well. But Now Another Thing.

When there is a Credit Balance in Balance TextBox, It Shows A Negative (-)
Sign with the Amount.
How Can I Remove That.

Thanks

 

[Damon Heron]

Somehow I knew that would be your next question....
You will need to modify your two textbox control sources slightly.

The balance text box should be :
=Abs([text1]-[text2])
Abs is short for absolute value of the results so whether it is neg or pos
it always displays pos.

The DR CR box should then be modified to use the two textbox computations
instead of the balance:
=IIf([text1]-[text2]<0,"CR","DB")

Damon

Add yet another textbox to the right of the balance textbox. Set its
align
property to Left. In the
controlsource, type: =IIf([yourBalancetxtboxname]<0,"CR","DB")

Damon

WoW , Its working Well. But Now Another Thing.

When there is a Credit Balance in Balance TextBox, It Shows A Negative (-)
Sign with the Amount.
How Can I Remove That.

Thanks

 

[malik via AccessMonster.com]

Somehow I knew that would be your next question....
You will need to modify your two textbox control sources slightly.

The balance text box should be :
=Abs([text1]-[text2])
Abs is short for absolute value of the results so whether it is neg or pos
it always displays pos.

Ohhhh
Its Not working. It has done wronge everything. Now the function is adding
all the amounts and does not Minus
And Dr And Cr is Also ot Working Properly.

 

[Malik via AccessMonster.com]

Somehow I knew that would be your next question....
You will need to modify your two textbox control sources slightly.

[quoted text clipped - 3 lines]

Abs is short for absolute value of the results so whether it is neg or pos
it always displays pos.

Ohhhh
Its Not working. It has done wronge everything. Now the function is adding
all the amounts and does not Minus
And Dr And Cr is Also ot Working Properly.

Hi Damon,

I Have Done it By Myself. I learned some new thins from u.
Now See what I did.

I used 1st method that u told me in which Negative Sign ( - ) was Appearing,
But Calculation Was Ok And Dr Cr was also fine.
I Created 1 New Text boxes in report with name"Bal1" And Then set its
Control Sourse =Abs([Balance]), used Balance Type TextBox with It and set
Balance Textbox Visible Property to False.

U done Much for me.

Tons Of Thanks

Regards

Malik