Unique value

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

Using Access 2000

I know that you can use a query that will either give you unique values or
unique records by specifying it in the properties of the query. Unique
values will depend upon the fields being displayed and unique records will
look at the whole record to decide if it's unique or not. What I need to do
is display 5 fields and have the unique feature only look at one field not
all the fields being displayed.

Pete Provencher
 
Try a totals (group) query. It won't be updatable.

SELECT FieldA,
First(FieldB) as XFieldB,
First(FieldC) as XFieldC,
First(FieldD) as XFieldD,
First(FieldE) as XFieldE
FROM YourTable
GROUP BY FieldA
 
Thank you so very much. I had to make a new table with just the information
that I was looking for, but once I did that, everything worked perfectly. I
learn so much from the newsgroups. Thanks to you and all the others that
share their knowledge.

Pete Provencher
 
Back
Top