Need help building queries

[bacardi451]

Hi,
I am trying to build a querie from a table.
The form is a vessel tracking database.
which contains Vessel Name, Type, and Id number and date enter port and date left port.

As the vessel goes in and out of port a record is made everytime.
I have one vessel that are in 6 records with diffrent dates and another vessel with 3 records.

I am trying to construct a query where it only gives a list of vessel in the records but I do not want duplicates.

Example. (if I do a normal query this is what I get)
vsl sunshine Id Number: 00001
vsl sunshine Id Number: 00001
vsl sunshine Id Number: 00001
vsl sunrise id number: 00002
vsl sunrise id number: 00002

This is what I would like the list to appear
vsl sunshine Id Number: 00001
vsl sunrise Id Number: 00002

Thank you
Al

 

[Mile-O]

Use the query wizard to make a Find Duplicates Query.

 

[neileg]

Or you can cheat and make this a totals query and select max of ID. It's not clever, but it works.