Obtaining a Unique Record

L

Lorgia

How do you get a unique record out of a query? My query contains multiple
records, but I only want to filter out the unique ones.
 
K

kingston via AccessMonster.com

I'm not sure if this is what you mean, but in visual design mode, open the
query's properties window (right click on query background and select
Properties...). Set Unique Values to Yes.
 
J

Jerry Whittle

Good question. Some sample data and expected results would be nice too.

Also I'm wondering if Lorgia wants only the unique records or wants the
unique records excluded from the result.
 
Top