Same value multipal times displaying

A

ATanker62

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.
 
P

PC Datasheet

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.
 
A

ATanker62

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.
 
P

PC Datasheet

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.
 
Top