I have an address report that I am making. All would be easy in a simple universe. I am trying to get only one address per person (There is a person table, and an address table(one to many)). Now to complicate matters I want only their preffered address. There is a field called preffered address, however, people with only one address may not have this field checked.

I have done this through code, but I want to see if there is another way to do this, maybe more efficiently.

I have also tried using distinct, but as was pointed out to me, that works oon the whole recordset, not just one field.

Thank you

I would imagine that people with only one address should have that address marked as preferred anyway?