unique records

[tina]

Hi
In a query I have gone to properties and changed unique records to yes but
I am still getting unique records the query is one field only
Any ideas
Thanks
Tina

 

[KARL DEWEY]

This is like saying 'I have cut the wire 5 times and it is still too short.'
Setting the property to Yes means you only want unique records so that is
what you get.
Post example of your data and what you want the query results to look like.

 

[tina]

Hi
Thanks for reply . When I set query to unique records only I thought I would
get only unique records
I am using a query with 3 fields finished good stock code description and
component
but query is just component field but am getting following data
Component
AFB016
AFB016
AFB016
AFB016
AFB016
AFB016
AFB072
AFB106
AFB106Y
AFB110Y
AFB114Y
AFB174Z
AFB174Z
AFB174Z
AFB174Z
AFB176Z
AFB177Z
AFB178Z
AFB179Z
AFB180Z
AFB180Z
AFB180Z
AFB181Z
AFB181Z
Regards
Tina

 

[KARL DEWEY]

Try UniqueValues. See explainations below. Or use a Totals query.

UniqueRecords ---
You can use the UniqueRecords property to specify whether to return only
unique records based on all fields in the underlying data source, not just
those fields present in the query itself.

UniqueValues --
You can use the UniqueValues property when you want to omit records that
contain duplicate data in the fields displayed in Datasheet view. For
example, if a query's output includes more than one field, the combination of
values from all fields must be unique for a given record to be included in
the results.