Log in

View Full Version : Opening and Closing balance in access report.


montashir
Apr 26, 2008, 04:15 PM
I want access 2003 to generate the goods sold account report showing
the opening and closing Balance. I have the issued qty. and sold qty.
and the closing balance is an calculated value (issued qty. - sold
qty.). Now, I want the report show the result as per my given starting
date and show the opening balance that should be the same of the
closing balance of the previous date. How it can be done? Please help
urgently.


Thanks in advance,
Montashir

ScottGem
Apr 26, 2008, 04:26 PM
Use a DSUM() function to add the incoming and subtract the outgoing. O do it in a query and use a DLookup.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

montashir
Apr 27, 2008, 12:26 AM
Use a DSUM() function to add the incoming and subtract the outgoing. O do it in a query and use a DLookup.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA


Thanks Scott, But I am a newbie so could you please send me an example and detail walkthrough. It would be very helpful for me.

Waiting for your reply
Montashir

ScottGem
Apr 27, 2008, 08:04 AM
Look up DSUM or Dlookup in Access Help, that will give you detailed explanation on how to use those functions.

As an aside, we volunteer our time on sites like these. Very often our answers are just to give you the direction you need to get where you want to go. You shouldn't expect to get a detailed, step by step answer (though sometimes you might). You really should rely on the Help files for details.