duplicate records

[Guest]

I have a property management database that has many of the same tenant names
but at different street address but same mailing address. I want to run a
query that only shows the tenant once.

 

[John Spencer]

More detail on what you want returned would be nice.
Do you want just the tenant name and mailing address returned? Assuming
that the Tenant name and mailing addresses are consistent across your
records (big assumption) then you just need to return only those fields and
set the query's unique values property to YES. (Right-Click in the grey
area at the top of the design view of the query, select properties)

From the very little you have said it seems as if you don't have a separate
table of tenants but are re-entering all the tenant data for each property.
Your design should probably have at least two tables.
Tenants (and details about the tenant)
Properties (with one field referencing the primary key of the tenants
table).

A Primary Key is one field (or one set of fields) that uniquely identifies a
record in a table.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..