how to compare 2 values in a report (Invoice Total vs Payments)

[Rita]

while running a report how would I set a message "out of balance" if
my invoice amount (Table 1 ) does not equal the value of my total payments
(table 2). If the values were the same then no message would be printed.
Thank You

 

[Olduke]

Create a new command button to check the report before you print it.
You will have to enter code for the button along the lines of:

If [Invoice Total] <> [Payments] Then
MsgBox "This account is out of balance"
Endif

 

[Duane Hookom]

You haven't told us anything about your report's recordsource :-( Do you have
fields with this information?

Can we assume you want a text box or label in the detail section that states
"out of balance"?