unique value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I write a SQL statement where I want one field unique (MasterCodeID)
but several other columns from the same table, say Field 1, Field 2 that are
not unique?
Thanks
 
Hi,

Your question could be interpeted different ways. How about showing us some
of the existing data, with the real table and field names, then what you want
this data to look like.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Question 2
Access Query - "Duplicate Records Selected" 5
Create a distinct Join 3
query to filter by current record id? 4
Unique Query in not working correctly ... too complex? 2
UnMatched Query 2
field value concatenation VBA 1
Unique Values only please 7

Back
Top