I wanna compare a numeric value (value#1) in a table to another numeric value (value#2) in a query. Value#2 is a calculated field in a query produced by an expression that won't let me input it at the table level.
IF value#1 is greater than or less than value#2, I would like a message box to appear notifying me of the values.
Any ideas?