Microsoft Office Tutorials and References
In Depth Information
Finding Duplicate Records
The handy Unique Values and
Unique Records properties
Sometimes, rather than finding duplicates and
deleting them, you just want to hide them. You
may need to see only a list of states that your
customers come from; you don’t need to see
Massachusetts 56 times (if you have 56
customers in Massachusetts).
The property sheet has two properties that
allow you to hide duplicate values:
Unique Values Set this property to :
Yes when you want to see only unique
values for the fields displayed in the query.
The Unique Values property omits
duplicate data for the fields selected in the
query. Every row displayed in the query
datasheet is different.
Unique Records Set this property to :
Yes when you want to see only unique
records based on all fields in the underlying
tables. The Unique Records property
affects only fields from more than one
table. A record is considered to be unique
if a value in at least one field is different
from a value in the same field in another
record. Note that the primary key fields are
included when records are compared.
To display the property sheet, right-click an
empty part of the Table pane in Query Design
view (the top half of the design grid) and
choose the Properties option from the
contextual menu, or click the Properties button on the
toolbar.
The Unique Values and Unique
Records properties apply only to select,
append, and make-table queries. Note that
when both are set to the No value (which is
the default), the query returns all records.
Book III
Chapter 3
Search JabSto ::




Custom Search