getting rid of repeptative records

[bauer]

I have a query that has addresses, there is a field called preffered address, which if they have 2 addresses, this is clicked for that address.

My problem:
I want to only show all of the addresses, and if one person has two, only the preffered address

thank you

 

[shacket]

Use an IIf statement:

FinalAddress: IIf(Nz([PreferredAddress]) = "",[RegularAddress],[PrefferedAddress])

This would create a field named FinalAddress which, if nothing was in the preferred address, would be populated with the regular address.

 

[bauer]

to clarify, prefferedAddress is a yes no, and if it's yes, the associated address should be kept, otherwise it should be deleted.
Thanks