Unique value

[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

 

[John Spencer (MVP)]

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

 

[Pete Provencher]

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