Duplicate items removal

[Xenix]

I have a problem, I have a quotations database I have two tables one for customer details with the quote number and one to hold all the part numbers for that quote.

Now I what to generate a query that will show all the quotes for that area e.g. UK.
Problem is it show all the quotes but with many duplicates where that quote number is there in the products table where there are several items under that quote number is there a way?

Kind regards

Mike

 

[Mile-O]

You could try constructing a Find Duplicates Query with the query wizard, and then edit it accordingly.

 

[Xenix]

Thank you again

as I was looking how to do what you said I found under properties there was a section saying "unique records" and it was set to no. So as you can guess after changing it seems to work fine ))))

Thank you for your right directions )