Jump to content
  • 0
MaximeV

Recherche stricte à partir d'une variable

Question

Bonjour à tous,

J'ai défini une variable, que j'utilise dans une fonction recherche.

La fonction recherche fonctionne bien.

Mon soucis, c'est que lors de la recherche, par exemple pour le compte "MARIE", il me trouve 2 enregistrements : "MARIE" et "MARIEY".

J'aimerais que pour le compte "MARIE", il ne me trouve que l'enregistrement "MARIE", et non "MARIEY". (un peu comme l'emploi du "==" dans une recherche classique)

Comment forcer cette recherche stricte dans la fonction recherche, s'il vous plaît ?

Cordialement,

Maxime V.

 

 

Capture d’écran 2018-03-22 à 12.42.22.png

Capture d’écran 2018-03-22 à 12.43.38.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

5ab396b194e82_Capturedecran2018-03-22a12_42_22.png.49ea8800f9e6cf1c77771a255c7e4a1d.png

5ab396f223b79_Capturedecran2018-03-22a12_43_38.png.cd33292a4b8243407b0f5bbfca473bff.png

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 1

Bonjour,

 

dans le calcul, tu mets ceci : "==" & $Compte

Share this post


Link to post
Share on other sites
  • 0

Bonjour,

Cela fonctionne. Merci à tous les 2 pour votre réponse très rapide.

Cordialement,

Maxime V.

Share this post


Link to post
Share on other sites
  • 0

Souvent oublié, FileMaker affiche le menu des opérateurs lors des recherches.
image.png.34dbe3a659a6af1315c7b34cd513e878.png

Ca sert de pense pense-bête.

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

image.png.34dbe3a659a6af1315c7b34cd513e878.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...