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

[Guest]

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.

 

[Marshall Barton]

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.

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\#"))