Limit display of duplicate

[Jengminchen]

Hi Guys,

I have a Table that stored movies. As there are multiple copies of the same movies each with its own unique Id such as 0001-1 and 0001-2 for copy number two. However as both have the same movies title, how could I limit the query to display only one entry for each movie. Any help or suggestion would be much appreciated. James the novice, so be gentle!

 

[Jon K]

In the query grid, set the following in a column:-

Field: InStr([ID],"-1")
Show: uncheck
Criteria: >0


This criterion will return only IDs with "-1"

 

[Jengminchen]

It worked! Thanks a million Jon for your prompt reply. Much appreciated as I almost give up after a week of trying.