Same value multipal times displaying

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

Guest

I have designed a query that returns titles of work and where they were
submitted, the same titles appear numerous times, I wish for each unique
title to appear only once.
 
Open your query in design view. Right click in the query window where your
tables are. In the dialog that appears, change Unique Values to Yes.
 
Thanks but I did that and the data displayed when the query runs is exactly
the same. Maybe I should have mentioned that I am running Access 2000 sorry
that I did not give enough information at once.
 
You have other fields in your query besides title and where submitted that
make the records unique. A possibility is the primary key; remove it from
your query.
 
Back
Top