How do I create a field that shows opening balance on a report

K

Kwashie

I am creating a program to keep track of the financial transactions for a
school. I put in a date parameter at the query level which allows me to
preview selected data in a report for the date I specified.

I now want to include a field in my report or form which will display an
opening balance as the sum of all values up to the beginning of my defined
period in the parameters.
 
M

Marshall Barton

Kwashie said:
I am creating a program to keep track of the financial transactions for a
school. I put in a date parameter at the query level which allows me to
preview selected data in a report for the date I specified.

I now want to include a field in my report or form which will display an
opening balance as the sum of all values up to the beginning of my defined
period in the parameters.
Click to expand...


You can use the DSum function to do that. Without more
information, all I can suggest is using a text box with an
expression like:

=DSum("amount", "thetable", "datefield < " &
Format(parameter, "\#m\/d\/yyyy\#"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate beginning balance, but print details on report 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Create report that shows a previous balance as of a date entered on a form 6
Balance Forward 4
Access Opening Balance Expression 25
Report Help - Starting/Ending Balance 7
Calculating an inventory balance at a "point in time" 5
Creating a Search using a combo box and then creating a report. 4

Top