Building a report displaying only record where 2 fields are different

Building a report displaying only record where 2 fields are different

Hi,

I have 1 form Form A, I like to check where 2 fields are identical or not (displaying only the diff would be better)

This Form_A has 2 fields:
Field_A : text field with content coming from a import
Field_B : look up field linked to Form L

The Form_L contains 1 text field named Field_L
Data in Form L contains all the unique occurrence existing in Form_A / Field_A.

As an administrator, I like to get a report of all record with mismatching Field_A / Field_B of Form_A

A normal report can only filter with fixed value, not from other field value.

However I don't see how I can proceed. Should I build a page or a report ? The condition should something like (please correct me)

if ( Field_A != Form_L [ ID == Field_B ].Field_L )
{
  // display record
}
else
{
  // don't display record
}

Do you have any suggestions ?