I have an app with the following columns

MemberName, MemberLastName, MemberQualified, PartnerName, PartnerLastName, PartnerQualified

In this application either the Member or his Partner or both can be "Qualified".   The Qualified field can either be YES or NO.

I want to create a report or view that will show one line FOR EVERY Member OR Partner that is qualified.   In other words, if there is only one entry in the DB, but BOTH THE MEMBER AND PARTNERS IS QUALIFIED, I want to show TWO LINES in the report.

I hope this makes sense?   Even more, I hope someone took the time to read through it and can help.   Please.