duplicates

[bigmac]

hi, i need to use a query but not to allow duplicates, example field [place] if there are two places called "wales" then only show first one not all of them, any ideas please

 

[recyan]

SELECT DISTINCT 
	place
FROM 
	myTable
ORDER BY 
	place;

Thanks

 

[bigmac]

how do i put that into the criteria please?

 

[recyan]

how do i put that into the criteria please?

What criteria?
There is very less information in what you have posted ( at least for me).
If you post a little bit more information on the table data & what you want out of it, it would be easier for someone to help.

Thanks

 

[bigmac]

the code that you gave me where do i put it please is it vba or an SQL if SQL how to i place it?

 

[recyan]

It is the code for a query. Save it as a query after replacing the table name with your table name & the field name with your field name.

Thanks

 

[bigmac]

cheers recyan, thats the first time i have tried SQL and it works

 

[recyan]

cheers recyan, thats the first time i have tried SQL and it works

Sorry, Did not realise that you were new to SQL & queries, else would have explained it differently.
Glad u got things working.

Thanks