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

  • Thread starter Thread starter Rita
  • Start date Start date
R

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
 
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
 
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"?
 
Back
Top