Unique values for a field

Kozbot

Registered User.
Local time
Today, 12:26
Joined
Jan 16, 2013
Messages
110
Hello

I have a material usage table that tracks material going into products

Oftentimes the same material will be used and multiple records will contain that material.

I want my query to return only records with unique material used. I'm clicking the "Unique Values" and "Unique Records" property setting but its not working.

What am I doing wrong?
 
Create a TOTAL Query to count the material, then join it with the Main Query and use the criteria as the count field = 1.
 

Users who are viewing this thread

Back
Top Bottom