Limiting data? please help

B

BVG HOA

I have a residential database and in the query, I want to sort by who is the
resident of the unit, instead of displaying if it is the owner or tenant of
the unit. How can I limit this data?
 
Top