Limit search result to 1

[maxpouliot]

Here's my query :

SQLmail = "SELECT e.courriel FROM valideurs AS v LEFT JOIN employes AS e ON e.id=v.employe WHERE v.statut='Actif' AND v.demande = "& idDemande & " ORDER BY hierarchie"

I need to limit the search result to 1. I know in php/MYSQL i could add LIMIT 1 to the query but this doesn't work with access

Anyone can help?

[Beagle]

Google: limit clause MS ACCESS
First hit answers your question
Please, try to find the answer for yourself before you ask others to figure it out for you.