Obtaining a Unique Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Access Query - "Duplicate Records Selected" 5
Unique Count 1
Unique Records 6
unique records 3
Update Query for Multiple Records 4
Query to show 2 records from each unique entry in a field 2
Need a query to get rid of duplicates using two tables 1

Back
Top