Report Totalling Problem

[Stewman]

Hello All,

I am having a problem with a report. I have a report that needs to pull a current balance off of a form. The current balance is calculated on the form, is not a field in the table. I can get the report to show the balance only if the form is opened. I was wondering if there is a way to have the report show the total without the form being opened.

If there is no way to have the balance show without the form opened, then is there a way to have the form open without creating a macro. Any VB coding or some other trick.

Hope this is not confusing.

Thanks, Stewman

 

[scriverb]

Why not include the current balance as a column in your Record Source query. You have not given us any specifics here but the query that feeds your report can calculate the currentbalance in the same way that your form did.

Post back if you have any questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[Stewman]

Scriverb,

I tried this before and tried it again and it doesn't work.

My current balance is calculated on the form by taking my beginning balance + the deposit balance - the total amount spent (This total is derived by summing the total amount spent field in the records inputted into the form).

I tried inputting the formula into the query that makes my report but it doesn't work. Any other suggestions?

Thanks Stewman

 

[scriverb]

I recently wrote a function to perform CurrentBalance value in the following thread: thread703-867810

This query calls a function and passes the pertitient ID value and within the function just such a current balance is calculated and returned. Sounds like a similar thing could work for you.

Take a look and tell me what you think.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]