How do I find records where the Maiden Name is the same as the Last Name on a Constituent record. How to query on records where Maiden Name and Last Name match. Find records where Maiden Name and Last name are the same.
It is not possible to have Query compare one field to another on a record to return results. This would require a query to locate Constituent records that have a Maiden Name. Then create a Constituent export to Excel that has output of both the Last Name and the Maiden Name. Create a formula in Excel to compare the Last Name to the Maiden Name to determine if they match.
NOTE: Creating formulas in Excel is outside the scope of Blackbaud Product Support.