G Guest Nov 14, 2006 #1 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.
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 Nov 14, 2006 #2 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.
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.
G Guest Nov 14, 2006 #4 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.
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.
