If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculated Field on Form needed on Report
I have a report that list the balancedue. The balancedue is calculated from
the total due - paymentstotals on the main form. After a payment is posted, a receipt is printed and if a balancedue exist, the balancedue letter is generated. How do I go about getting the balancedue without referencing the form. FYI, I did have the report referencing the balancedue on the form and it cause lot's of problems. Considering that the balancedue is a calculated field, should I calculate the balance and save it to the table? Thanks, Ray. |
#2
|
|||
|
|||
Calculated Field on Form needed on Report
Ray Todd wrote:
I have a report that list the balancedue. The balancedue is calculated from the total due - paymentstotals on the main form. After a payment is posted, a receipt is printed and if a balancedue exist, the balancedue letter is generated. How do I go about getting the balancedue without referencing the form. FYI, I did have the report referencing the balancedue on the form and it cause lot's of problems. Considering that the balancedue is a calculated field, should I calculate the balance and save it to the table? You could recalculate the balance due in the report. OTOH, using the value from the form is ok as long as the form is open and the value has been calculated before the report is opened. What kind of problems did you have with this approach. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Calculated Field on Form needed on Report
Marshall,
The problem that I was having is the "looping" that I was describing yesterday in another post on the forms/coding board. (Looping might not be the best word to use, however, that what it appears to be doing when looking at it on the screen) I finally narrowed the problem down to this individual report and then ultimately the one field (on the report) that referenced a calculated field on the open form. "Marshall Barton" wrote: You could recalculate the balance due in the report. OTOH, using the value from the form is ok as long as the form is open and the value has been calculated before the report is opened. What kind of problems did you have with this approach. |
#4
|
|||
|
|||
Calculated Field on Form needed on Report
That problem! Oh my, that is a nasty situation. You must
have done some serious debugging to pin that thing down. Good work. (Don't ask me to explain why/how it happens to exhibit that symptom) You should(?) be able to perform the same calculation in the report, which is not a bad thing if it's relatively simple. If it has any degree of complexity, you may want to encapsulate the logic in a standard module function that you can use form both the form and report/ -- Marsh MVP [MS Access] Ray Todd wrote: The problem that I was having is the "looping" that I was describing yesterday in another post on the forms/coding board. (Looping might not be the best word to use, however, that what it appears to be doing when looking at it on the screen) I finally narrowed the problem down to this individual report and then ultimately the one field (on the report) that referenced a calculated field on the open form. "Marshall Barton" wrote: You could recalculate the balance due in the report. OTOH, using the value from the form is ok as long as the form is open and the value has been calculated before the report is opened. What kind of problems did you have with this approach. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Combo Box NotInList - How To Add Data To Underlying Table | 10SNUT | Using Forms | 19 | July 8th, 2005 09:12 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |