Uniqueness in Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
Please give a bit more information about what you are trying to do.

How do I ensure no duplicates records for numeric field in Access query?
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Can you be a bit more specific?
Do you want to return only one record for each unique number along with
other fields?

Do you want to return records that don't have any duplicates of the number?
That is if the number exists two or more times in the table don't return any
records?

Or are you trying to force the table to not have duplicate numbers?
 
One of the fields is numeric and may be repeated in additional records in the
table becuase it is a flat table. The second field in the query is a text
field. What I am trying to query is how many records in the numeric field
are uniqure (no duplicates)in that table.
 
A Query on just the numeric field with the "Unique Values" property
set to True should give you the right number of records.

One of the fields is numeric and may be repeated in additional records in the
table becuase it is a flat table. The second field in the query is a text
field. What I am trying to query is how many records in the numeric field
are uniqure (no duplicates)in that table.
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top