conditional sum in form

[spooky30]

Hi all

I want to display income and expense seperately on the form till the time of last transaction--in cash book,where i will enter transactions.

Issue:

How do i display total of income and expense seperately on form using conditional sum on date,income/expense , or any other way to do it

 

[apr pillai]

Try This,

Create 2 Text Boxes on the Footer of the form

Write the Formula on the Control source Property of the Text Box

=DSum("Amount","TableName","Amount >0")
for Income Values - assuming that these are entered in Amount Field as positive values

=DSum("Amount","TableName","Amount <0")

for Expenses Totals.


visit my site http://msaccessblog.blogspot.com/ for tips and tricks in Form Desinging.

 

[apr pillai]

Try This,

Create 2 Text Boxes on the Footer of the form

Write the Formula on the Control source Property of the Text Box

=DSum("Amount","TableName","Amount >0")
for Income Values - assuming that these are entered in Amount Field as positive values

=DSum("Amount","TableName","Amount <0")

for Expenses Totals.


visit my site http://msaccessblog.blogspot.com/ for tips and tricks in Form Desinging.